Show all values pivot table

[emteam162]

Hi all,

I need your help, i want to show all values in a dimension

Finally i want to display this pivot table

Name	Reg	Prod	value
a	aa	Prod1	0
	aa1	Prod2	2
b	bb	Prod3	0
	bb1	Prod4	0
	bb3	Prod5	5

when user select " a " i will have in my pivot table

a	aa	Prod1	0
	aa1	Prod2	2

Have you any idea to to that

Many thanks for your help

Emteam

[Nicole-Smith]

The built in QlikView pivot table should give you what you're asking for (see attached).