I've created a Pivot Chart. I need to sum all values in a field up to selected year for the selected dimension.
For example, if user selects year 2017, the values in field Inception should be summed up for years 2016 and 2017, assuming available data starts in year 2016. If user selected year 2018, values in field Inception should be summed up starting in 2016, 2017 and 2018; etc.
Sample data in attached file.
Not working. 😞
I've tried all of these options, but none have worked.
Hi, I was using the year field in the calendar table for the Years List Box. Now I'm using the Year field in the fact table, which works precisely.