For simplicity's sake lets assume I have a fact table that says:
Account, Account Name, Amount
1 Blah 100
2 Blah2 50
And a hierarchy table that says:
Account Category
1 Current Assets
2 Current Liabilities
Using this I get to a pivot table that shows me:
Current Assets
Blah 100
Current Liabilities
Blah2 50
I now want to Net working capital to appear at the bottom as a calculation. So:
Current Assets
Blah 100
Current Liabilities
Blah2 50
Net working capital 50
How do I do this when my fact table does not contain any "category" of Net working capital (so even if I insert it into my hierarchy table it won't show up)?
Account, Account Name, Amount
1 Blah 100
2 Blah2 50
And a hierarchy table that says:
Account Category
1 Current Assets
2 Current Liabilities
Using this I get to a pivot table that shows me:
Current Assets
Blah 100
Current Liabilities
Blah2 50
I now want to Net working capital to appear at the bottom as a calculation. So:
Current Assets
Blah 100
Current Liabilities
Blah2 50
Net working capital 50
How do I do this when my fact table does not contain any "category" of Net working capital (so even if I insert it into my hierarchy table it won't show up)?