Ok, I have a pivot tabel with:
article (rows),
price (rows) and
kilo (value)
The only thing that is accumulated is the kilo.
So now i want to now how many kilos that are in different intervals, for different articles
Example:
article 1 - price 10£ to 20£ - 2000 kilos
article 1 - price 20£ to 30£ - 1000 kilos
article 1 - price 30£ to 40£ - 4000 kilos
article 1 - price 40£ to 50£ - 5000 kilos
article 2 - price 10£ to 20£ - 1000 kilos
article 2 - price 20£ to 30£ - 4000 kilos
article 2 - price 30£ to 40£ - 4500 kilos
article 2 - price 40£ to 50£ - 70000 kilos
How do I do this?
Bookmarks