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
