1 2 Previous Next 27 Replies Latest reply on Jan 11, 2017 4:04 PM by Shinichiro Murakami Branched to a new discussion.

    Remove empty columns from year over year calculation

    mark.welsh

      In the attached workbook, I don't want to see the columns where there is no data. 

      I need the end result to look like the below (we can ignore the budget calcs for now) with column headings accordingly as well.

      I'm going to have something like 30 different dimensions to perform these calculations on, so I can't really create calculated fields for each dimension.  I mean I probably can, but if that's what it comes down to I'll need to re-evalute. 

       

      I wonder if I can use LOOKUP or PREVIOUS VALUE?  I've never used those; would they have to be at the dimension level or can I apply to a measure and inherit the dimension form the view? 

        1 2 Previous Next