Break month sort when trying to add conditional

Mon, 28 Apr 2014 08:05:09 GMT

I have conditional,that if i have last no full month,i must put zero on all rows in table.

I put if on the top quotient(divider) if,like:

if(Year=Year(Max(%Date)) and Month=Month(Max(%Date)),0,

Sum({<[Основной поставщик]={'test},FlagThisMonth={1},[Month]=,Year=>}[MySum])

) //End if

Sum(DISTINCT{<[Основной поставщик]={'test'},FlagThisMonth={1},[Month]=,Year=>}

Aggr(NODISTINCT Sum({<[Направление]={'ЛЮКС'},FlagThisMonth={1},[Month]=,Year=>}[MySum]),[Numenclature Group],[Month Year]))

This count aggr quotient by group in pivot table

But,when i select some month,like february - this month becomes first in dimensions.How i can disable this?

Thx for helping

topic Break month sort when trying to add conditional in QlikView