Hi,
I've built a analysis modell for actuals vs budget. My boss wants to be able to see the verification text for the actuals while still having having the budget figurrs in the same pivot. The verification text is in the fact_Actuals and because of that I get an error in the Budget column, the budget value for that account repeats for all verification text rows. How do I solve that problem?
Example below.
Thanks,
Caj
<tbody>
</tbody>
I've built a analysis modell for actuals vs budget. My boss wants to be able to see the verification text for the actuals while still having having the budget figurrs in the same pivot. The verification text is in the fact_Actuals and because of that I get an error in the Budget column, the budget value for that account repeats for all verification text rows. How do I solve that problem?
Example below.
Thanks,
Caj
Account | AccountName | Verifacation text | Actual | Budget |
4000 | AAAAA | AAA | 25 | 150 |
BBB | 150 | |||
CCC | 150 | |||
DDD | 25 | 150 | ||
Total | 50 | 150 |
<tbody>
</tbody>