Hello,
I am creating an active report, using cube as my data source.
This is the scenario, i have to display a measure in my report, i am using a repeater table for this which provides me extra items option to filter the data. I added two different dimensions, like year and product type and quantity is my measure.
I want my report to show the quantity as one aggregated value over all the years and product types by default. But my report is showing data for combinations of the two dimensions.
For example, i want total quantity to be displayed as 10000, but i am getting two different values for the two years i have,
6500 3500
If add more dimensions along with year , it is showing all the combinations.
Is there a way for my report to show the default value as total for all the dimensions, like
Years -> All
Product Type -> All
If i select any year, then my measure should be total for
years ->2013
Product Type ->All
Please reply if the explanation is not clear.
Thanks for your time.