Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Can anybody tell me how to add dummy dimension in pivot level chart
Sarfaraz
Not sure what you mean by Dummy Dimension, but if you mean to add a dimension which isn't available from the database, you can try ValueList() or ValueLoop() functions.
Hi,
I agree with Sunny.
If You use ValueList('a','b') as dimension, You need Expression Like
If(ValueList('a','b')='a',Sum(TOTAL <DIM> Value)) and so on.
See sample attachment.
Regards
use Valuelist function
Go to chart properties -> Dimension tab
Add calculated dimension
=Valuelist ('Dummy1','Dummy2',..)
or if you want just single value as Dummy dimension, then add calculated dimension as below
='Dummyvalue'