I'm trying to get this table:
|Ledger||Actual until April '16||Budget unti April '16||Actual - Budget until April '16||Budget total '16||Forecast total '16||Budget total - Forecast total '16|
The first three columns there is no set analys, they're selected by the time dimension year-month. In the last three columns there's a setanalyse which selects the complete year 2016. When inserting this table into the excel sheet and filter the table on the dimension year-month, it also filters the last three columns.What am I doing wrong?
Thanks in advance,