All,
I tend to prefer lurking over posting questions, I do enjoy the challenge of finding answers, however this one has me stumped and can use the help.
Situation:
I have two tables that are joined by a single common key, in which one table has a Hierarchy of [Collection Leader], [Team Leader], and [Collector] in side by side hierarchical columns. The other table is transactional information, that is linked based on the [Collector]'s ID.
Since this report will be used by many people in different levels within my business, I have been asked to put in a 'toggle' (can be a slicer or Option Radial Button(s)) in which a single Row dimension is controlled and gives the viewer the option to see the pivot table by either [Collection Leader], [Team Leader], or [Collector] columns, with the default at Collection Leader and only one option can be chosen.
I also need to use PowerPivot, (which is still a little new for me) based on anticipated size of data and some of the advanced formulas such as using Percentiles.
Any links to articles or hints on how to approach greatly appreciated.
Thanks in advance!
Dmarq
I tend to prefer lurking over posting questions, I do enjoy the challenge of finding answers, however this one has me stumped and can use the help.
Situation:
I have two tables that are joined by a single common key, in which one table has a Hierarchy of [Collection Leader], [Team Leader], and [Collector] in side by side hierarchical columns. The other table is transactional information, that is linked based on the [Collector]'s ID.
Since this report will be used by many people in different levels within my business, I have been asked to put in a 'toggle' (can be a slicer or Option Radial Button(s)) in which a single Row dimension is controlled and gives the viewer the option to see the pivot table by either [Collection Leader], [Team Leader], or [Collector] columns, with the default at Collection Leader and only one option can be chosen.
I also need to use PowerPivot, (which is still a little new for me) based on anticipated size of data and some of the advanced formulas such as using Percentiles.
Any links to articles or hints on how to approach greatly appreciated.
Thanks in advance!
Dmarq