flat table widget of MTD & YTD values should show status wise

[gsunilkumar145]

Hi All,

I have created MTD & YTD columns based on date filed but now i want to show the MTD,YTD values based on the other column called status.

If user filter november month , then table should show the values status wise MTD value & till November value of YTD (not just november sum alone). 

[v-yanjiang-msft]

Hi @gsunilkumar145 ,

Sorry I'm not very clear about your problem, seems there isn't month column in the sample, would you like to add more description?

Best Regards,
Community Support Team _ kalyj

[gsunilkumar145]

Hi ,

Requirement:

Yes, i dont want to add month column in flat table but i will add month column in slicer. If i filter for novermber month it should show the YTD value of november as showin in image of thread question.

Currently if i filter for november it is showing the YTD value same as MTD because those are dynamic calculation measures.

The above added image showing current month value of MTD & YTD but it is extracted from a flat table.

Option:

I thought to create the flat table by using the Date column, MTD & YTD calculated formula but am unable to create it because MTD&YTD values are measures not the columns.

Hope my requirement is clear , can you please suggest /guide me .?

Regards,

Sunil Kumar