Eliminate/Hide value repetition in chart

[BootCam]

Value Repetition:

The calculation for Notional amount is: Sum({<[Cost Type Code]={'WPP'},[Cost Status]={'OPEN','PAID','VOUCHED}>}[Cost Amount])

The calculation for MTM Value is: Sum({<[Cost Type Code]={'WPP'},[Cost Status]={'OPEN','PAID','VOUCHE}>}[TidMarkToMarket Open PL])

Now, we have cost amount which is not repetiting here but the MTM value is repetitive because of the association.

If you look at the total then you can see we are getting exact value for MTM. Its not adding up all the repeating values.

But i need to hide the repeating values from the UI.

Is there anyway i can do that from the UI?

Regards,

SK

[ziadm]

Hi

Use the expression Text color .. set the color to white if the value is equal above value ...

=if(Sum(sales) = Above(Sum(sales)),White(),Black())

[Anonymous]

Most likely your chart is correct, and the repetitions have valid reasons.

The rows of the table are defined by the combination of chart's dimensions.  If you provide information about the dimensions, it would be easier to help you (if it is indeed necessary).

Possibly it can be done by removing a dimension form the chart, and replacing it with expression.

[BootCam]

Hi Ziad,

It doesn't work with the expression you mentioned.

the original expression is for MTM: Sum({<[Cost Type Code]={'WPP'},[Cost Status]={'OPEN','PAID','VOUCHE}>}[TidMarkToMarket Open PL])

I used this in the text color:

=if(Sum({<[Cost Type Code]={'WPP'},[Cost Status]={'OPEN','PAID','VOUCHED'}>}[TidMarkToMarket Open PL]) =Above(Sum({<[Cost Type Code]={'WPP'},[Cost Status]={'OPEN','PAID','VOUCHED'}>}[TidMarkToMarket Open PL])),White(),Black())

Still doesn't work.

Thanks,

Sk

[ziadm]

Hi SK

I am sure that you have a syntax mistake .. try to copy the formulas into expression and check the syntax  and see if yo getting results of the Above(sum ()) ...

[Anil_Babu_Samineni]

Interesting, Already mov provides valid and make sense too

Can you provide more information, I meant to say data or sample QVW, We can say ??