Trick to add a merged cell header on top of a dynamic dataview ?
Julien CARDON
Customer
Hi all,
We have a P&L dataview with a lot of columns so it is hard to read (and the request is to keep it like that because it should be exported to Excel in 1 block)
Business need
The business team wants to add a header on some columns (similar to merged header cells in Excel) with the last month selected in the SELECT to better explain the content of the data view
Issue
=> I have created another dataview with only a header, on top of the main dataview to simulate the merged cells but I'm not able to display in that dataview the name of the last month selected in the screen (currently it always display "Last Month" while we want to display "Feb 21" or "Dec 21" depending on the user selection)
I cannot create a label with @Selection_EX(Entity="Month", Interval="Last") because the length of the dataview is changing depending of the number of months selected by the user
Here it should display "Feb 21" instead of "Last Month"
And here "Dec 21"
What I have tried / Issues I'm facing
- @Selection_EX(Entity="Month", Interval="Last") is not working in dataview (nor in the header nor in the layout) so I'm using right(@Month,6)
- But @Month in a dataview do not behave the same as in a label : Once there is more than 10 months members selected, Board is displaying "11/34" and not Nov.21 +
- I don't know if it's possible with Nexel ? (I'm bad at it)
- I cannot use a technical month dimension because users are selecting month through the screen select or month selectors and not procedure
Any idea is appreciated!
thanks,
julien
We have a P&L dataview with a lot of columns so it is hard to read (and the request is to keep it like that because it should be exported to Excel in 1 block)
Business need
The business team wants to add a header on some columns (similar to merged header cells in Excel) with the last month selected in the SELECT to better explain the content of the data view
Issue
=> I have created another dataview with only a header, on top of the main dataview to simulate the merged cells but I'm not able to display in that dataview the name of the last month selected in the screen (currently it always display "Last Month" while we want to display "Feb 21" or "Dec 21" depending on the user selection)
I cannot create a label with @Selection_EX(Entity="Month", Interval="Last") because the length of the dataview is changing depending of the number of months selected by the user
Here it should display "Feb 21" instead of "Last Month"
And here "Dec 21"
What I have tried / Issues I'm facing
- @Selection_EX(Entity="Month", Interval="Last") is not working in dataview (nor in the header nor in the layout) so I'm using right(@Month,6)
- But @Month in a dataview do not behave the same as in a label : Once there is more than 10 months members selected, Board is displaying "11/34" and not Nov.21 +
- I don't know if it's possible with Nexel ? (I'm bad at it)
- I cannot use a technical month dimension because users are selecting month through the screen select or month selectors and not procedure
Any idea is appreciated!
thanks,
julien
0
Answers
-
Hi Julien,
Have you found a solution to create a header to group the columns without using labels? I'm looking for a solution not using a label because the label's position on the screen is static and will not move with the columns below it.
Thank you,
Yvonne
------------------------------
Yvonne Tran
Systems Associate
Wedbush Securities Inc.
United States
------------------------------
-------------------------------------------0
