Select exact value in pivot with a variable

[ecems]

Hi everyone,

I want to select a specific value in a pivot; I use this expression and it works

{<GROUP={'Group1'},Category={'Complaint'}, Year={'2023'},Month={'2'}>}Count(TICKET_ID)

But; I dont want to change script every month; so I want to use a variable in this script but it doesnt work. Instead of Month={'2'}; I tried:

• Month={($(vmonthtoday))} ,
• Month=month(today())

How can I solve this problem?

Thanks

[MayilVahanan · Accepted solution]

Hi

Try like below

{<GROUP={'Group1'},Category={'Complaint'}, Year={'2023'},Month={'$(=Month(Today()))'}>}Count(TICKET_ID)

[ecems]

Yeyyy, It works! Thanks a lot 🙂