I have a calculated measure in SSAS cube used in excel pivot table. My issue is that the calculated measure treats totals as lines and applies the formula to the aggregated totals of the fields. An example using order lines:
Order1 | A | B | C | D |
---|---|---|---|---|
product1 | 1 | 40 | 0 | 0 |
product2 | 40 | 1920 | 20 | 960 |
product3 | 1 | 24 | 0 | 0 |
product4 | 2 | 32 | 0 | 0 |
product5 | 2 | 27 | 0 | 0 |
product6 | 1 | 760 | 0 | 0 |
product7 | 1 | 2880 | 1 | 2880 |
product8 | 1 | 872 | 0 | 0 |
product9 | 2 | 1680 | 0 | 0 |