Forum Discussion
Dashboard & Pivot tables help
Riny_van_Eekelen This looks good with the attribute column, Making the charting more versatile.
If I was to update this Dashboard with new data added into CMO input Tab and Forecast Input tab, will this automatically update the Pivot, as the master data is going in Power Query?
excel_learner Can't really predict how this will work in the dashboard you are building, as I haven't been able to look at it.
How would I just add the top row as another column so each heading is attributed to the subheadings.
it happens once you transpose table, but then the week no have separate columns which I don't want.
Is there a way I can just get the week no back to rows ?
excel_learner Looked at the original file again, but can't tell how an update would work. The file contains 12 queries, all of which seem to have issues. So, I can't check any of them to see how they will be affected.
Then, I don't really understand your last question about "weeks not having separate columns".
