scripting

[sunitha_chellaiah]

Hi All,

I want to get below output using backend  scripting.

Please use attached data to get the output.

Thanks.

[Arthur_Fong]

Hi Sunitha,

Cant view your expected output.

Could you please re-upload again?

Thanks and regards,

Arthur Fong

[ecolomer]

Can you explain a bit more your need?

[sunitha_chellaiah]

I want below mentioned outputs using back end script only

Output 1: Sales_Amount with Region totals appearing below cities

Output 2: %age value of (Sales_Amount / Total Sales_Amount)

Output 3: %age value of (Sales_Amount / Total Sales_Amount) considering only region wise totals

1. All three output values to be achieved through back end scripting only. Only Sum() in front end to be used. Output should be calculate and acomodate if in case of new rows added
2. Use only Straight table. No Pivots. Only One dimension and three expressions to be used in the chart
3. Sorting of Regions and cities can be achieved with front end or even back end. But it should dynamically get sorted in case Regions or cities are increased within the data.

[ecolomer]

Is that?

[sunitha_chellaiah]

I want the output using straight table only

[manoj217]

can you please share your expected output clearly

[ecolomer]

This?

[ksomosera10]

Hi Sunitha,

You can create a pivot table or straight table with the "City" as the dimension.

Then on the Expression, use the provided formula. The output should have (3) expressions for these:

• Output 1: Sales_Amount with Region totals appearing below cities
• Output 2: %age value of (Sales_Amount / Total Sales_Amount)
• Output 3: %age value of (Sales_Amount / Total Sales_Amount) considering only region wise totals

You can then add then the compass as another dimension.

Thanks!

[sunitha_chellaiah]

Output is correct. but i dont want to do any front end calculation. Simply i want to use sum() and only one dimension to be used.