Pivot Table>>How to conditionally show dimension?

[#1]

Hi Qlikview Experts!

How do I hide a dimension for a given expression?  My pivot table has the below dimensions and expressions. For a given expression, I want to hide dimensions.  For example, for the dimension, "Ben Income ($)", I only want to show "Ben Revenues".

Dimensions:

1. ProductionCategory
2. MonthYear

Expressions:

1. Net Production ($)
2. Ben Income ($)

H

[ecolomer]

Is that you need?

Can you upload an example with data?

[#3]

Yes, I think that's what I want to do.  I'd have to see the code. 

Attached is my code and data. 

[#4]

Can you post your QVW?

[ecolomer]

Hi,

after studying the data, I think the best solution is to create a load script sencilllas clusters of concepts