set

[Dolly123]

=sum({< FiscalYear=, FiscalMonthName=,
Date={"$(='>='& Date(Monthstart(max(Date),-6)) &'<'&Date(Monthstart(max(Date))))"}
>}[Capacity (TR/HP)])

i want add this formula in set and last 6 month above code

sum({<Stage="won">}capacity)/sum(capacity)

[vikasmahajan]

Hi,

SUM({< Stage = {'won'},Date = {">=$(=Date(AddMonths(Max(Date ),-6),'MMM YYYY'))<=$(=Max(Date ))"} >} [Capacity (TR/HP)])
/
SUM([Capacity (TR/HP)])

Can you try this.

Vikas