Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have the following expression :
Sum(Aggr( Max({<Quarter={"$(vPriorQuarter)"} , Month={"$(vPriorMonth)"} , WeekYear={"$(vPriorWeek)"} , Date={"$(vPriorDate)"}>} AccSales),StoreName))
This expression sum the total accsale all store. It is ok for text box and straight table. But I use for the custom table that isnt work.
Can anyone help me??
it's straight table
it's the custom table
Thank in advance.
Maybe you get what you want using the TOTAL qualifier:
//3
,Sum(TOTAL Aggr( Max({<Quarter={"$(vPriorQuarter)"} , Month={"$(vPriorMonth)"} , WeekYear={"$(vPriorWeek)"} , Date={"$(vPriorDate)"}>} AccSales),StoreName))
HI,
Try this
Sum({<Quarter={"$(vPriorQuarter)"} , Month={"$(vPriorMonth)"} , WeekYear={"$(vPriorWeek)"} , Date={"$(vPriorDate)"}>} Aggr( Max({<Quarter={"$(vPriorQuarter)"} , Month={"$(vPriorMonth)"} , WeekYear={"$(vPriorWeek)"} , Date={"$(vPriorDate)"}>} AccSales),StoreName))
Regards,
Jagan.
it still isnot work
I think you create a new table and add expression again hope it works
kirkleehuang : I try your solution but It doesnt worrk
Maybe you get what you want using the TOTAL qualifier:
//3
,Sum(TOTAL Aggr( Max({<Quarter={"$(vPriorQuarter)"} , Month={"$(vPriorMonth)"} , WeekYear={"$(vPriorWeek)"} , Date={"$(vPriorDate)"}>} AccSales),StoreName))
Hi swuehl ,
Thank you so muchhhh ......