Expression based on condition

[#1]

dim1	product	price	amount	total
xxx	A	2	2	4
xxx	B	6	1	6
xxx	C	3	3	9

I want to hide price and amount from product B and only show totals for the products A en C, i cant figure this out in Qlikview.
any suggestions?

Im using a pivot table with three expressions:

Amount:

(sum(amount)/count(DISTINCT Month))

Price:

(sum(total))/

(sum(amount)/count(DISTINCT Month))

total:

sum(total)

[Chanty4u]

may be this

[sunny_talwar]

Like I mentioned here (condition based expression), would you be able to share a sample?

[buzzy996]

do u like this?

[swuehl]

And please don't create multiple threads for the same topic, it's really hard to follow a discussion.

Seems you got a similar answers in both threads anyway