5 Replies Latest reply: Nov 15, 2017 3:20 PM by Sunny Talwar RSS

    Calculated Dimension or Set Analysis?

    Dan Green

      I've created a pivot table that shows department, month, and year dimensions and has three expressions for the totals columns. I want the chart to only show 3 months of data, with this always being the most recent three months of data.

       

      Can this be done with a calculated dimension rather than set analyis? I think I would need to add a set expresssion to ALL three expressions right? I'd rather avoid that if possible due to formatting in the expression to make it show as hh:mm:ss.

       

      Any tips are appreciated!