Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to create a table in the front end , where its not affected by a selection.
So for example: I have customers with the following back orders:
Customer Qty on Back Order
Customer A: 20
Customer B: 50
Customer C: 80
Total 150
So if I have a list box of of Customers and I select customer A, I want a table to show both 20 and total of 150. (as per below)
Customer Qty on Back Order Total Qty on Back Order
Customer A 20 150
Basically, how do I do the scripting to display total qty of 150.
kind regards
Nayan
Use as expression in your table sum({<Customer=>} [Qty on Back Order]) for calculating the total qty on back order.
Try
=$(=sum({<Customer= >} [Qty on Back Order]) )
to evaluate the expression in the TOTAL context.
Or, to ignore all selections:
=$(=sum({1} [Qty on Back Order]) )
Hi Gysbert
It worked. Thanks. Lets say now the qty on back order is for specific items: So if we expand, for example:
Customer Item Qty on Back Order
Customer A:
Apples 5
Bananas 10
Pears 5
Customer B: Apples 20
Bananas 30
Customer C:
Apples 40
Pears 10
So if, we have the same customer A selection, I want it to display the following:
Customer Item Qty on Back Order Total Qty on Back Order
Customer A Apples 5 65
Bananas 10 70
Pears 5 15
Now, for the Total Qty on Back order , how do i do the formula. The one that you have given me above , for each line , it displays 150.
Try sum(aggr(sum({<Customer=>}[Qty on Back Order]),Item))
