Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need help with set analysis for my pivot table, please.
I have Effective Months = EFF_YYYYMM which is a dimension in pivot table above
ARCHIVE_DATE is also dimension in Pivot table
SUM(Bin_Distribution) is an expression with calculated numbers
I need to create set analysis inside "Visual Cues" for Bin Distribution
where number for Bin Distribution is compared to previous ARCHIVE_DATE (within the same EFF_YYYYMM) and it highlights if this number is less than original in yellow/red.
I enclosed excel file with some snapshots.
I appreciate your help very much.
Dear Gennady,
You had better to introduced a conditional expression in the "Visual Cues" which will identifies the "True" or "False" of the condition. Then you can set the color accordingly.
Regards,
Priyantha.
Dear Priyantha,
Thank you.
This is exactly what I am asking - I need to write set analysis formula into "Visual Cues", but not sure how to do it....