how to add rows?

[shruthibk]

Hi all,

i got requirement to find the total.where the total will be sum(product b and product C)  but i have product a also ,how can i achieve this in pivot table?here the fields value a,b,c coming from different qvd's which i taken into same field.plz help me to achieve this asap.

i have to build the same chart as showing in excel,

plz find the sample data

[Gysbert_Wassenaar]

You can't add rows to a table in a pivot table. You could abuse the partial sums to use the total line to show two values. Enable the Partial Sums option of the Product dimension and use an expression like:

If(Dimensionality()=0, sum({<Product={'b','c'}>}Value) & chr(10) & num(sum({<Product={'a'}>}Value)/sum({<Product={'b','c'}>}Value),'0.0%'),sum(Value))