YTD Sales Based on Month Filter Selection

[sarithaallot]

Hi Team,

I am Trying to create Bar chart for YTD Sales Based on my Month selection That means if i have selected Mar Month we should get Jan+Feb+Mar.

Iam Using Qualify statement for my table.

My dimension is Role.for calculating Ytd sales for selected Month.Iam  using this formula

Sum({<[Sheet1.Date]={"<=$(=Max(Sheet1.Date))"},[Sheet1.Month]=>} [Sheet1.Sales])

Note:this formula working if i have not apply any qualify statement.Sum({<[Date]={"<=$(=Max(Date))"},[Month]=>} [Sales])

Here i am using Sheet1.Date and Sheet1.Sales Because iam using qualify statement for this table.

[sarithaallot · Accepted solution]

I found solution for YTD Sales Based on Month filter.

YTD Sales formula:Sum({<[Date]={"<=$(=Max(Date))"},[Month]=>} [Sales])