Subtotal in pivot table

[vijetas42]

Hi all,

I want to display only total values in pivot table wherever my are same for each row irrespective of column position.

Regards,

Vijeta

[sunny_talwar]

Not sure I am clear as to what you are looking for. Do you have a sample you can provide with the expected output?

[vijetas42]

No     Name     Vendor     Date            value1         value2

1       n1           v1         28/09/2015    1243413      351355

2       n1           v1         28/09/2015    1243413      351355

         total                                        1243413      351355

expected output,

No     Name     Vendor     Date            value1         value2

1       n1           v1         28/09/2015   

2       n1           v1         28/09/2015   

         total                                        1243413      351355

[karthikoffi27se]

Hi Vijeta,

Can you use this function

=If(Count(Distinct Field1) = 1, Null(), Sum(Amount))

this should work.

Thanks

Karthik

[sunny_talwar]

May be use dimensionality() and/or SecondaryDimensionality() functions to populate only totals

How to use - Dimensionality()

The second dimension... or how to use secondarydimensionality()