Hi all,
I have a data source, with various projects (rows) and sub-projects (new column, various rows) and various budget columns and a cost column per year for various years (please see simplified version attached).
I have created a calculated field per year, but is there a way for me to group the years to show only the result unless I expand it? I have too many years a different columns per year so when it shows all its very confusing. I was trying to see if I can do this with a Power Pivot, but I am not an expert in it. Any ideas?
Thanks a lot.
Bookmarks