nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Conditionally Show/Hide Group Levels in a Crosstab

JanaF

Hi, 
 
I would like to build a crosstab, which looks like the following: For the current month and the month before the group levels should be shown whereas for earlier month the group levels should be hidden. In the Example below the current Month is "march" 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>| | amount
______|_______________|_______
Jan | Sum: | 50
Feb | Sum: | 70
| calender week | 30
| calender week | 20
| calender week | 10
| calender week | 10
March | Sum: | 80
| calender week | 30
| calender week | 20
| calender week | 20
| calender week | 10</pre>
 
Is there a way to conditionally display the group levels? 
 
Thanks in advance!

Find more posts tagged with

Comments

JanaF

I was able to hide the data fields itself by establishing a visibility rule for these fields. I used the rule 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>current month - row month <= 1</pre>
 
But by doing so the rows themselves are still visible (just empty). 
 
How can I really hide the whole row? Maybe by using scripting? 
 
Thank you for any ideas