Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
How to added total in List box
For example, we have Value in List box like Below.
List
a1
a2
b1
b2
Now i need like
List
a1
a2
total of A
b1
b2
total of B
Please help me regarding this
Regards ,
harish
The listbox is not designed for such a task but pivot-charts are. Just create a main-category to your sub-category field within the script and then using both fields as dimensions with partial sums and an appropriate expression to them will serve your task.
- Marcus
Dear Marcus ,
Thanks for Your replay,
There only one field , how to have these above totals in Pivot. any idea ??
regards,
harish
You could use something like: left(List, 1) as a calculated dimension and List as second dimension within the pivot. But like above mentioned it's often better (by large datasets, multiple use of the logic, need to apply aggr() functions and/or TOTAL statements within expressions and so on) to do such categorizing within the script.
- Marcus