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.