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