Back end scripting

[sunitha_chellaiah]

Hi All,

Please achieve the below outputs with the attached data set through back end scripting only.

Where

Actual Sales Value = Quantity * Price

The below points should be considered while achieving the output.

1. All outputs to be achieved through back end scripting only. Only Sum() in front end to be used.
2. Only Straight tables. No Pivots. Only One dimension and three expressions to be used in the chart
3. No changes to the data set to be made.

[swuehl]

What's the logic behind the last two columns so we don't need to guess?

[sunitha_chellaiah]

Sales_Ouput_1 - It is just a cumulative addition(Full Accumulation)

Sales_Output_2 - 2 steps accumulation

[Peter_Cammaert]

I guess stuff like this is much simpler to accomplish in the front-end (using Above() & friends) than in the back-end.

But anyway, that's not your question. Consider using an AsOf-table. The concept is explained here: The As-Of Table