How to find a specific value in the pivot table

[#1]

Hi,

I am quite new to the QlikView. I do not know how to find a specific value in the pivot table.

For example, this is a three dimension (A, B, C) pivot table:

C1 C2 C3

A1 B1 X1 X2 X3

B2 X4 X5 X6

A2 B1 Y1 Y2 Y3

B2 Y4 Y5 Y6

I want to calculate Y1/X1, Y4/X1, Y2/X2, Y5/X2, Y3/X3, Y6/X3... In that case, I need to find the value (X1) with dimension A=A1, B=B1, and C=C1. Do you have any idea how I can find the specific value in pivot table?

Thanks in advance!

[#2 · Accepted solution]

filter in pivot table : select fields A B C

or

use Macro to find a value in table

[#3]

Thanks!

Problem has been solved

Danni