8 Replies Latest reply on Aug 9, 2018 2:49 PM by yannis vossos

    Calculating Subtotal in Rows & Variance in Columns - is it Possible?

    yannis vossos

      Hey Guys, I need to create a report as below. I have an oracle star schema, my fact measure is "Total" and I also have dimensions , Account and Scenario.

      I need subtotals of accounts in the lines, and variance of Budget - Actual (scenario dim) in columns between scenario Actual & Budget;also need a kpi arrow or color based on the value of the variance

      I tried many ways to no avail, I created both my account and scenario dimensions as measures each time. But not both , it seems impossible is it even possible?