I can't manage to send qlikview file, only pictures or link ...
You can load this script :
LOAD * INLINE [
Store, Product, Sales
'A', 'P1', 5
'A', 'P2', 3
'A', 'P3', 3
'B', 'P1', 1
'B', 'P2', 2
'B', 'P3', 3
'C', 'P1', 2
'C', 'P2', 4
'C', 'P3', 2
After, add a select object for Store and construct this cross table (Store * Product) and sum the sales :
Store Product P1 P2 P3 A 5 3 3 B 1 2 3 C 2 4 2
I would like to have the same things but instead of Store 'A', 'B' and 'C', I would like to have another dimension
- Group 1 : selection of the select list of Stores (Several stores can be selected)
- Group 2 : the total of the Stores.
The exmple is very simple but in reality, the number of Stores is very important and it is impossible to write all the values.
Many thanks for your help.