Conditionally hiding pivot table total values

[#1]

Hi,

Please take a look at the attached sample file. Here, when user selects  'hide' in the list box, I would like to display a '*' for all quantity expressions. The thing I can't figure out is how to hide a row's total if any of the values of the expression for that row is less than 10. In this example, the second row for toyota hides the blue quantity (since it's 8), but it shows the total value of 18. Obviously, user can deduct the blue quantity by subtracting this total from the red color quantity. How could I hide the total for this row and only show the 10 quantity for blue color.

[perumal_41]

HI

PFA application.i thing solve your problem.

Regards,

Perumal A

[#3]

Hi,

Thanks for your reply. I see that this solution worked perfectly on my sample application. However, my production table is much more complicated than this example, and I also use ODBC connection to pull in data directly from the source. In order to implement this solution on my real table can you explain this syntax you sgguested:

sum({<key={"=sum(quantity)>=10"}>}quantity)

What exactly is happening here?

[perumal_41]

Hi,

first create unique key  based color and car.

sum(quantity)>=10 then unique key  rleated value take for calculation ,otherwise not take.