Conditional Expression

[upaliwije]

I have following pivot table in My Doc

I want to show under the Financial Institute Column only Institutes which exceeds only 10% of total Value-2016

eg:  Arpico Finance= Net Total/Total

                                  75836/77277= 98% to be shown

       Natition Insuranec Brokers= 2200/77277= 2.8% not to be shown

My Calculated dimension for Financial Institute is

Can you suggest me solution for this  and It should be for pivot table please.

[prma7799]

Please share some sample app.

[sunny_talwar · Accepted solution]

This?

[upaliwije]

Thanks Sunny

It is really amazing your solutions. However When I apply this to my original document I get an additional row just below the total row. What could be the reason ? Further I can not understand this 1e10 . Pls  help

[sunny_talwar]

Just check 'Suppress When Value Is Null' for your first dimension on the dimensions tab of chart properties

[upaliwije]

Thanks a lot Sunny