Adding budget information to an existing document.
Hi.
I need a little push in the right direction. I´m adding a budget dataset into an exsisting dataset. My problems are in how to link the budget with the actual data. I have a working file, that is it works unless any selections are made. Then the selections affect the available data from the Budget. (like selecting year could limit my number of charge codes from the actual). I can handle that with set analysis:
{$<year=>}
(I want the ability to limit the actual AND budget when selecting charge code, but I dont want the budget limited by seemingly unrelated selections, like year.
I´ve included a demo document that has some data in it, a chart with the dimensions I want to use and the sums. I just feel that I´ve muddled up the data a fair bit to get the Budget linked with my Actual data. Is there another way to accomplish this?
