11 Replies Latest reply on Nov 8, 2016 6:18 AM by Yuriy Fal

    Trellis chart with stacked area chart based on a second dimension

    sanjiv raman

      I was able to create a simple trellis chart based on the column (IIF([Index]%8==0,8,[Index]%8)) and row ( INT(([Index] - 1) / 8) + 1) both calculated at the location level. Now, I would like to add another dimension "business" to create a stacked area chart. The moment I add business, the index gets messed up as it's defined only at the location level. How can I best resolve this issue? Would I need to alter the row and column calculations such that [Index] is a unique value for each location instead of an index?