Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 years of data, and i am creating one Pivot Table where
Category is Row,
Month from date('MM/DD/YYYY') is Column and
sum(amount) is measures.
I need to see last 4 months from the Report Running date or selecting a date from filter, Please help how to show only 4 Months data in Pivot Table.
Thanks,
Sorry, I cant able to provide sample.
I just need a column expression for getting 4 Months data from 2 yrs data.
Thanks,
change ur measure from
sum(Value)
to sum({<Date={"<=$(=date(max(Date),'MM/DD/YYYY'))>=$(=date(monthstart(addmonths(max(Date),-5)),'MM/DD/YYYY'))"}>}Value)
this is working, But when selecting the particular month, the data in dashboard should change accordingly.
If i am selecting the month September in filter pane the result should be last 6 months from September(Apr,May,June,july,August& September data).
Help me to achieve this.