Forum Discussion
ROYMMM
Advocate II
Advocate IIHide future months in matrix
Hi, I have a report with a matrix showing the availability of services. Every column represents a list of availability percentages of the respective services for a specific month. The matrix shou...
HI ROYMMM,
You can add if statements to your measure formula to check date and skip calculations on records that greater than current date. If full of row/column does not contain valid values(no blank value), they will be hidden by visual itself.
If you confused about coding formula, can you please share some dummy data to test? It is hard to clearly your table structure form matrix snapshot.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng