if( Valuelist($(vListHeads1)) ='Cost of Sales', $(vCostOfSalesCY),
if( Valuelist($(vListHeads1)) ='GP', $(vGPCY),0
This function works fine.
Now I need to use a pivot table to show the trend by month of these variables. The filter is based on the month. If I have no selection, it shows totals for all months of the current year. but when I select a month, it don't show the totals (by month) for the that year. it just shows that month only.
The below is the formula I have used for vSalesCY.