Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team,
I have a below data and i need to show the data only for last 5 days , last 60 days in my pivot table .
So here is my expected output, Dimension will be 'LOB' and measure is Count(issue_no) and measure 2 -sum(opendays).
So , the above measure should show the numbers for last 5 days on the basis of report_date. Can anyone please help ?
Thanks in advance.
Count( {< Date={">=$(=Date(max(Date)-5))"} >}[column A])