Pivot Total -- Can we just have onlya total of a particular expression?

[#1]

Hi,

Is it possible to create a Pivot chart with 2 Dimensions and 3 expressions where for the 2nd and 3rd expression, i just want to show the Totals against the dimensions without detailed values?

Please suggest the options.

The displayed values are of Sold price, But i want to show the actual price in the form of Totals only. Is there a way to do this?

[petter]

Just disable or remove the product dimension.

[satishkurra]

Try this

In expressions tab, add 1 expression as Dimensionality()

Observe the dimensionality is same for Total and different for other individual values

Try with the below expression

=if(Dimensionality()=0,Sum(Sales)/Sum(TOTAL Sales),NULL())

[satishkurra]

Check if the attached qvw helps

[#5]

Thanks a lot for the quick reply.

But accordng to requirement, i have to display the Totals as row (as per the screen shot -- like rows), not as columns. Is there a away fo aceive this?

If you observer, i also have another dimension called Year, which is pivoted to the top as per requirement.

[satishkurra]

Take Year as dimension and Drag a cross load . This is allowed in Pivot table

[#7]

yes, that is done. I am looking out for Expression issue. need a logic to display only totals of 2nd expression under the totals of first expression.