Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to get below output using backend scripting.
Please use attached data to get the output.
Thanks.
Hi Sunitha,
Cant view your expected output.
Could you please re-upload again?
Thanks and regards,
Arthur Fong
Can you explain a bit more your need?
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
Is that?
I want the output using straight table only
can you please share your expected output clearly
This?
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:
You can then add then the compass as another dimension.
Thanks!
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.