Sum of sales limiting Day(DateTimeNow()) - 1, ParallelPeriod or Limit

[Hesloan Viana]

Hey all, i need to create a Bar Chart that shows me how the atual month is going compared to other months limiting the Day(DateTimeNow()) - 1.

Example:

If today is day 28 of August. I need to see, in my bar chart, the Sum([sales]) for all months (including August) until day 27.

If today is 2 of September then i need to see, in the bar chart, the Sum([sales]) of day 1 for all months .

I've tried using ParallelPeriod and Limiting Data likeDay([date_sale])=Day(DateTimeNow()) - 1, but it doesn't work.

[Khushboo Rabadia]

It would be great if you can provide the sample dataset and expected output numbers as above description is confusing i.e. Bar chart should show numbers till priorday or all months should show 1 or 13 or 27 days numbers based on the prior date