Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Just disable or remove the product dimension.
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())
Check if the attached qvw helps
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.
Take Year as dimension and Drag a cross load . This is allowed in Pivot table
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.