Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can someone help me to solve this.
I have included the details in the attached qvw file.
I need to calculate number of weeks each style_color_code is sold.
Units Field - number of units sold, if units is -1, 1 unit is returned. no need to consider returns.
Regards
Sujay Babu@
Hi,
Sum(Aggr(Count ( DISTINCT{<Units={'>=1'}>}Merch_Year_Week),Style_Color_Code,Merch_Year_Week))
Hi,
Sum(Aggr(Count ( DISTINCT{<Units={'>=1'}>}Merch_Year_Week),Style_Color_Code,Merch_Year_Week))
Thank You, It worked.
Regards
Sujay