I've got a cross-tab containing retail pricing by retailer (columns) and commodity (rows). In the data set, each row for a retailer and commodity also has flag to denote that price as an "ad" price or not. I have a simple IF statement checking that value to change the background color of the field, but the value of the 1st row in the data set is used for the entire cross-tab.
I've found references that say the CurrentFieldValue function as necessary for formatting cross-tab fields but because I need to base the background color on a different value that want's displayed I can't figure out how to make it work for me.
Any tips??
I've found references that say the CurrentFieldValue function as necessary for formatting cross-tab fields but because I need to base the background color on a different value that want's displayed I can't figure out how to make it work for me.
Any tips??