how to show all records that were considered in a SUM?

[#1]

Hi all,

I have a bar chart with one dimension (grouped to drill down).

There are several expressions, all aggregating certain data of my tables.

How could I get the detailed records that make up the calculated sum of one of the bars? Ideally I would like to have a straight table that just do show only the records that were used for the corresponding SUM calculation.

Thanks a lot

[swuehl · Accepted solution]

Maybe just create a staight table with dimensions including the field records you want to show and add all your expressions from the bar chart (you can hide the expressions on presentation tab). You may need to restrict to your bar chart dimension value by a calculated dimension or expression with a set analysis or selection in addition.

But, I think it would be much easier to discuss a solution if you could upload a small sample file or a detailed description of your data model and bar chart.

[Colin-Albert]

A pivot table will allow users to expand the dimensions down to a more detailed level. Or use a drill-down dimension group.

[#4]

Thanks,

that works perfect!

Bernd