Correction in the Expression

[Anonymous]

Hi,

Please help me...Is there something wrong in this expression.

Aggr(SUM({<Date = {">=$(=Date(Max(Date)-7,'DD-MMM-YYYY')))<=$(=Date(Max(Date)-7,'DD-MMM-YYYY'))"}>}Sales),Product)

its excluding last 7 days data. Actually I need only last 7 days data. instead of other

Thnx,

John

[PrashantSangle]

Hi,

Try like

Aggr(SUM({<Date = {">=$(=Date(Max(Date)-7,'DD-MMM-YYYY')))<=$(=Date(Max(Date),'DD-MMM-YYYY'))"}>}Sales),Product)

Regards

[MK_QSL · Accepted solution]

Assuming that your Date field is in DD-MMM-YYYY format.

SUM({<Date = {">=$(=Date(Max(Date)-7,'DD-MMM-YYYY'))<=$(=Date(Max(Date),'DD-MMM-YYYY''))"}>}Sales)

or

SUM(Aggr(SUM({<Date = {">=$(=Date(Max(Date)-7,'DD-MMM-YYYY'))<=$(=Date(Max(Date),'DD-MMM-YYYY''))"}>}Sales),Product))

[Anonymous]

Tried this before.....its showing all the data...Any other Suggestions Max....

Thnx

John

[MK_QSL]

What is the format of your DATE field?

[Anonymous]

Thnx Manish,

the second expression did the magic...cud u pls explain why Sum before Aggr ..made this work....

Thnx,

John

[MK_QSL]

SUM(Sales) will create TotalSales

Aggr(SUM(Sales),Product) will create a virtual table with Product as Dimension and SUM(Sales) as Expression

But we need Total SUM(Sales) for All Products... so we need to again use SUM

SUM(Aggr(SUM(Sales),Product))

[Anonymous]

Excellent!!!