Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a plan of projects for 2018 (red), I also have charged time for 2018 (Blue)
I have an issue because we have some projects from 2017 that charged in 2018 (projects from last year that carried over). I want to show how many hours have been used this year in comparison to the hours we have planned for projects this year. So I want the total of hours charged this year in comparison with projects planned for this year
TLDR: I want the two blue bars summed and represented next to the red bar with only the 2018 dimension showing.
Any help would be great!
So I figured out a way in which it would work for my situation.
I combined the dimensions using an expression. Basically if my year equaled 2017 or 2016 I made the if statement reassign them to 2018.
This showed all my data in one dimension.
=if(Year='2017','2018',if(Year='2016','2018','2018'))
So I figured out a way in which it would work for my situation.
I combined the dimensions using an expression. Basically if my year equaled 2017 or 2016 I made the if statement reassign them to 2018.
This showed all my data in one dimension.
=if(Year='2017','2018',if(Year='2016','2018','2018'))