Sorry VRT, let me explain a bit more..

The fact table has a dimension in it, which is deep and in one column. This column has 3 possible values. When I drag this column in the columns section in a pivot, the 3 values appear horizontally.

So.. the fact table is like this;

Acc Type Total

1 A 10

1 B 20

1 C 30

2 A 40

2 B 50

2 C 60

When I put a pivot on top of this, I'll want Acc in the rows, Type in the columns, and SumOfTotal in the values. This is when A B C will show horizontally.

I have managed to do a long winded workaround. I've created this measure;

TypesDifference:=(CALCULATE(SUM([Total]),Table[Type]="A") + CALCULATE(SUM([Total]),Table[Type]="B")) - CALCULATE(SUM([Total]),Table[Type]="C")

This gives me a measure that give me what I want. Only issue is, when I put it in a pivot, it duplicates the Type column because I have two values. It works, although a bit messy. Any other alternatives? Ideally I want the SumOfTotal to be split by the Type in the columns section, and the TypesDifference measure I created to be shown as only a grand total.