Announcements
cancel
Showing results for
Did you mean:
Creator

## Eliminate/Hide value repetition in chart

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

5 Replies
Specialist

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
Not applicable

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.

Creator
Author

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

Specialist

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 ()) ...

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 ??

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Community Browser