Make Folder & Column heading vary.

N&A Support Team

Hi everyone.

I received a requirement to make folder and column headings appear like this:

4/1  4/2  4/3    4/4  4/5  4/6  4/7 (Folder Heading level)

Mon Tue Wed  Thu  Fri  Sat Sun (Column Heading level)

where the first digit contains the month (for instance, 4 represents the month of April) whereas the 2nd digit would represent the day (both at Folder Headings Level)

At Column Headings level, we need to display the day of the week.

Basically, the need is, depending on the month selected, make both Folder & Column Heading levels vary accordingly.

Any suggestions are much appreciated.

Cheers, Angel

cesar.advincula.o

Hello,

1. You want to vary Folder Heading level in your "Criteria Tab", you cant do it, there is no a standard way. If you want to do something like this you should hack it.

2. The another thing, if you could reflect something the "Result Tab"

   - At "Column Heading Level", you could use presentation variable for getting some dynamic column, however it is not what do you need in your requirement.

 

      

Kind Regards,

Gianni Ceresa

Hi,

Do you have a measure for each single day?

I don't guess so ...

Why don't you use a pivot view and use your calendar dimension (if you don't have your date column) to have the date (month / day) and day name there on top ?

N&A Support Team

Hi all,

Thank you very much for your comments.

@ Gianni: You were absolutely right. In the end, this is exactly what we did and it worked fine.

Best Regards,

Angel

N&A Support Team

Hi all,

Thank you very much for your comments.

@ Gianni: You were absolutely right. In the end, this is exactly what we did and it worked fine.

Best Regards,

Angel