Forum Discussion

alann's avatar
alann
Frequent Visitor
6 years ago

Custom Mixed-Period Calendar Column

Hi Everyone, This one is driving me mad but hoping someone with a bit more experience than me can assist.   I have a simple calendar table (not truely this simple, but for the context of this forum...
alann's avatar
alann
Frequent Visitor
6 years ago

An update on this,

 

I have ended resolving this by creating a second table, linked to the Calendar table, with the static combinations of column sets based on the selected month. The month selection is now may on this secondary table, rather than the 'Calendar' table itself.

 

 

 

 

 

 

 

 

In this way when i select 'Jul' in the [Slicer Option] it filters for months Apr, May, Jun and Jul and i use the [Column_Set] field as the column in my matrix table. (see output below)

 

 

 

 

 

If anyone has any "smarter" solutions that wouldn't require a secondary static table please let me know else this is solved for now.

 

Thanks.