Current year sales

[Jsadhik]

if we have sales data of 4 years and want to extract current year/previous year sales , how can we do that?

i am trying to create a calculated field to get Current year sales, if I have to do it, i need to extract years from order date and compare with maximum of year of order date but if we create calculated field on this the data type show number, currency or percent

what other solution we have for this issue?

[neelay]

@Jsadhik
create the calculated field year from the sales-date (which includes only year)

and then pivot table where year is the column and sum of sales amount as calculated column…

[Koushik_Muthanna]

Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

Often you may want to create tables and other visuals which display multiple fields that are all ‘filtered’ to different date periods, as well as period-over-period fields. However we can’t use normal filters for this since filters get applied to all fields in the visual. Conceptually in this solution we are building the filters directly into the calculated field itself (using the ifelse logic), so that each field can have a different ‘filtered’ time period. You can then do whatever math you wan…