3 Replies Latest reply: Feb 15, 2012 9:59 AM by Thomas Ljungström RSS

    Fixing total in pivot

      Hi!

       

      I have a pivot chart where I show gross, refunds and net (with partial sums). No problem there.

      As dimension I use Group which values are gross, refund and net. Net is calculated as gross - refund.

      The problem occur when the grand total is calculated. I really just want to show the net.

      Straight table is NOT the answer, I have multiple dimensions.

       

      Found a solution where you create a assosiative table and somehow use that with aggregated values for dimension and then use the fact table for (pivot)total.

      But I can't get it in my head how to create that table. What to use as key?

       

      Really would like to be able to control what goes in the, grand, total with set analysis or something.

       

      Suggestions?

       

      Regards

      thomas