We have 2 Tables one is Sales table and other is the Lead Table. Let’s understand how we can link one slicer to 2 Pivot tables based on different data sources with the help of an example. You can also link one slicer with 2 Pivot Tables based on a different data sources. We can click on an item in a slicer to filter the data in the pivot table.Slicers provide buttons that you can click to filter tables or Pivot table. Slicer is a powerful way to filter pivot table data. Drill-down reports are used to validate and verify and also to zoom in to find particulars about a single value. Sometimes you may need to slice and dice or drill down for certain reports. Slice and Dice as you need for multiple data sources
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |