Dynamic Year
We have a year selection on a screen. Based on this selection, the data gets filter..
We have Columns like Current Year Budget, Prior Year Budget, Prior Prior Year Budget.
For eg: If i have year selected as 2020.
Then columns are 2020 Bugdet, 2019 LE, 2018 Actuals.....
I want to make the year part dynamics across the screen.
For Current Year, i am using @Year
Not sure what to use for Prior Year, and Prior Prior Year.
I have used these in both labels & dataview.
Please advise.
Answers
-
Hi GAURAV SINHA,
have you tried using a 'year' cube? Then you could use a layout on the labels. For the prior year you should be able to use the 'previous year' function
BR, Ray
0 -
Great Idea.
I am trying to achieve this in a dataview. So is there anyway i can make cube header dynamic in dataview?
0 -
To my knowledge the header depends on the name of the cube and the column axis value. If I understand correctly you won't have a column axis and so only static column names.
You could hide the column headers in the settings of the dataview
and put labels on top. I wouldn't recommend that because then the width of the columns can't be changed interactively.
BR, Ray
0
Categories
- All Categories
- 1.8K Forums
- 1.7K Platform
- 106 Academy
- 280 Resources
- 3 Community Captains
- 1 About Community Captains
- 1 Meet the Community Captains
- 1 Topics & Thought Starters
- Board Manual
- 50 Best Practices
- 41 How-To Guides
- 25 Board Advocacy Program
- 157 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- Academy
- 2 Board Academy
- 7 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.1K Idea Exchange
- 305 Partner Hub
- 2 Solution Sales Toolkits
- 91 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP