Displaying individual records that make up a sum in a pivot table

[#1]

This is a pivot table with Id as dimension, count, and two sum columns... How do I "expand" the 84 records that makes up the sum?  I want to see exactly what the 84 records that sum up to 11mil.

[Anonymous · Accepted solution]

Hi

I have knocked up the attached sample qvw.  It is a bit rough & ready, but should give you inspiration for what you are after - if it is of use & you have any questions regarding it then please ask.

Calculated dimensions can become very inefficient for large data volumes and ideally you should push things back to the load script and make sure you have a goo data model.  But no need to worry about that if you only have a small data volume.

Best Regards,     Bill

[#3]

Hi Bill,

Thanks.  Is there a way to sort on the =aggr() calculated dimension?

[Anonymous]

Hi

Yup

In Chart Properties | Sort

First deslect all sort on all dimensions.

For the dimension you want in sort order, add the aggr... expression as the expression for Sort by | expression.

Best Regards,     Bill