Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want to produce a pie chart where C is the total of the whole pie.
after selecting in field B, A=0 and B will be equal. but if you select in field A, C>B>A.
Thank you for this. Because of this i somehow understand how i will work on my current problem.
Here's how i got my ideal output.
=IF( ValueList('A', 'B', 'C') = 'A', if(count(GetCurrentSelections()>0) and getselectedcount([ID])>0,Sum({$}[A]),0),
IF( ValueList('A', 'B', 'C') = 'B', Sum({$}[B]), SUM({$}[C]) - Sum({$}[B]) ))
Thank you for this. Because of this i somehow understand how i will work on my current problem.
Here's how i got my ideal output.
=IF( ValueList('A', 'B', 'C') = 'A', if(count(GetCurrentSelections()>0) and getselectedcount([ID])>0,Sum({$}[A]),0),
IF( ValueList('A', 'B', 'C') = 'B', Sum({$}[B]), SUM({$}[C]) - Sum({$}[B]) ))