Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI Team,
I Need to create a Pie chart without dimension.
Exp = Sum(A)+sum(B)+sum(C)+Sum(D)
Dimension
=ValueList('A','B','C','D')
Measure
=If(ValueList('A','B','C','D')='A',Sum(A),
If(ValueList('A','B','C','D')='B',Sum(B),
If(ValueList('A','B','C','D')='C',Sum(C),
If(ValueList('A','B','C','D')='D',Sum(D)))))
I hope this helps,
Cheers,
Luis
Hello, i was looking for a something like this. Glad i came to this post.
Heads Up. It worked.
Many Thanks