Show client monthly Report

[knassoro99]

hello guys,

I'm working on a table called minus where I have created a slice to group client names. But now I would like to show client's name for the current month with their monthly total SUM? Right now it is showing Cleint name with grand total only. Please help!

[AleksiAlkio]

You need to have one extra virtual column with IFS() expression if the date belongs to this month. It would be IFS(EOMONTH([Date],0)=EOMONTH(TODAY(),0),[Total]).

[knassoro99 · Accepted solution]

Thank you I worked with additional Twik!