on 10-24-2015 5:11 PM
Hello All,
I have a requirement where I need to create a report which show last 12 months individually and its corresponding 12 values no aggregates.
Header Oct-14 | Header Nov-14 | Header Dec-14 | Header Jan-15 | Header Feb-15 | Header Mar-15 | Header April-15 | Header May-15 | Header Jun-Jun-15 | Header Jul-15 | Header Aug-15 | Header Sep-15 | |||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
KPI | A | A | ||||||||||||
B | B | |||||||||||||
A/B | A/B | |||||||||||||
KP1 | A | |||||||||||||
B |
Currently I have been trying with =currentdate()
From there I was creating Sep-15 but after 9 month I am not able to get Dec-14 at the same time corresponding A & B.
Any help is welcome.
Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
is there any specific reason to to extract 12 months data at report level by some variables.You can easily extract the 12 months data based on the user input prompt if you will create filter at universe level.
if back end database is oracle then add_months function in universe filter.for sql server dateadd function.
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.