Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a following data loaded inline.
Data:
Table:
Load * Inline [
State, City, Employee_Count
Maharashtra, Mumbai, 100
Maharashtra, Pune, 150
Gujarat, Surat, 80
Gujarat, Ahmedabad, 120
];
I want to have following output in straight table.:
Also I want to have scripting done in backend and changes to reflect in frontend.
How can I achieve this?
Actually Subtotals they are not possible in straight table.
using pivot table can be displayed as below, Check this may be helpful
hi
you can load another inline as
[City
Mumbai
Pune
Maharashtra
Surat
Ahmedabad
Gujarat]
Then you've to calculate based on that.
I don't remember exactly but someone may help.
Hi,
Try with attached file
Saludos.
Thanks everyone