Total over all values in a dim even when only a subset of dim is selected

[lmonincx]

Hi I am trying to establish that i see a total line including a complete totall (All) although for example only 2 out of 3 dim values are selected.

data would like to see by selection A and B

Pr qty % Pr Qty %

A 100 10% A 100 10%

B 500 50% B 500 50%

C 400 40 % Tot 1000 100%

tot 1000 100%

I am not able to get the Tot line like this, is this anyway possible?

[#2]

If you look at the help for the SUM function - Chart aggregation functions - you can see that the syntax of

sum( {1} Qty)

would give the total of all Qty on the entire document, disregarding the selections. Note the shape of all the brackets; this is because the '{1}' bit denotes a SET analysis construct.

Sorry if this is a bit late...

[lmonincx]

Hi Thanks, but with this I still see all the dims in the chart even if i only select 2 out of 3. due that i force the all with {1}, I am looking for a way that i only see 2 out of 3 dim values i select but the total line needs to display the complete total.

[#4]

Hi

Look at the attached QV doc.

-Raghu