-
MoM Variance in Pivot
Hi All is there a way to display the MoM Variance values in a pivot? for context i have data per day for Company, Division, Subdivision hierarchy, i can easily display the values at the end of the month in the hierarchy state but what i would like to do is calculate/display the monthly movement with the ability to drill…
-
Drill Path - ignoring of certain filters
Hi All i have a card which shows by employee actual % vs Target and the variance YTD (see below) i have added a quick filter to the card so a user can filter on employees who have a variance over a certain % so they can focus on the main drivers i then wanted a drill path to show the trend by (actual vs target) by month…
-
Pivot Table - Blank Column To Segment Data
Hi All i currently have a pivot on my dashboard with quite a lot of columns, to help users visually i wanted to segment slightly my thinking was to create a blank beast mode and add to where i wanted a break however it counts the rows does anyone know of a workaround? or another possible solution See below example (yellow…
