XLCubed Level Based Formatting
In this post I will show you how use conditional formatting based on level of the slicer.


In this example ALL, Year, Half Year and Quarter will be shown as x 1.000, month and day as real amount.
Create a slicer and set the Update Range:

On your Parameters sheet add the following to $B$1
=NUMBERVALUE(XL3PropertyLookup(1,"Date.Calendar",Slicers!A2,"LEVEL_NUMBER"))

On the XLCubedFormats page select the cell(s) you want to format and add conditional format based on the following formula:
=Parameters!$B$1<=3
in the custom part I used:
"€" #,##0,"k"; (#,##0,"k")
In a cell just above your table add:
=IF(Parameters!B1<=3,"Amount x 1.000 E"," Amount E")
Till Next Time
In this example ALL, Year, Half Year and Quarter will be shown as x 1.000, month and day as real amount.
Create a slicer and set the Update Range:
On your Parameters sheet add the following to $B$1
=NUMBERVALUE(XL3PropertyLookup(1,"Date.Calendar",Slicers!A2,"LEVEL_NUMBER"))
On the XLCubedFormats page select the cell(s) you want to format and add conditional format based on the following formula:
=Parameters!$B$1<=3
in the custom part I used:
"€" #,##0,"k"; (#,##0,"k")
In a cell just above your table add:
=IF(Parameters!B1<=3,"Amount x 1.000 E"," Amount E")
Till Next Time
Comments
Post a Comment