locked
How to include ratios as part of a row RRS feed

  • Question

  • Hello. I was reading up about cascading subtotals and it's complicated as a mofo, but is there any way that I  can include ratios? 

    For example, Sales, Cost of Sales....these can be included as subtotals no problem, but what about gross margin %? Donkeyshun. 

    Friday, November 4, 2016 9:43 PM

Answers

  • Hi AlexMartini,

    You can create a measure to calculate the ratio, so please describe what ratio you want clearly or post sample data.

    For another thing , in the Value field, Right Click->Value Field Setting, you can set the calculation type in “Summarize values By”, and “Show Values As” returns the presentation form.

      

    Best Regards,
    Angelia
    Tuesday, November 8, 2016 7:51 AM