row wise sum

[#1]

SUM({<Year={'$(vMaxPostingYear)'},DateNum={'<=$(vMaxPostingDate)'}>}[Sale Quantity])))

/

((SUM(TOTAL{<Year={'$(vMaxPostingYear)'},DateNum={'<=$(vMaxPostingDate)'}>}[Sale Quantity]))))

when I used it will total of all year ,but i need that sale should be divided by total of a particular month

[Anonymous · Accepted solution]

Try this one:

SUM({<Year={'$(vMaxPostingYear)'},DateNum={'<=$(vMaxPostingDate)'}>}[Sale Quantity])))

/

((SUM(TOTAL<YourMonthName>{<Year={'$(vMaxPostingYear)'},DateNum={'<=$(vMaxPostingDate)'}>}[Sale Quantity]))))

[#3]

excellent thanks:)