Hi all!
I've been banging my head for the past day trying to figure out something and was hoping I could get some help.
We have a crosstab report that needs to highlight a threshold on a value within a field. For example, the field, Procurement, has three values: Commodities, Other Services, and Prof Services. The request is to only have a threshold on the Other Services when it falls below 6%. I can easily do this on the column itself but it will highlight all values(Commodities, Other Services, and Prof Services) that fall under 6%.
Any assistance would be greatly appreciated.
Thanks
Hi,
Have you tried to apply conditional styles on fact cells like [Query1].[procurement] = 'Other Services' and [measure] < 6. Let us know if this works.
Good luck