show / hide column with condition in pivot table

[#1]

Hi

I want to show my result same as Fig1 instead of Fig2

is there any solution?

Fig1:

Fig2:

i want to show Count_No , Only in 2012

and not shown in other years.

thank you

[sunny_talwar]

The only way I can think of is to create field in the script using group by statement and then using it in the pivot table as a dimension instead of an expression.

Best,

S

[#3]

hi

could you help me to do this?

I can't do it myself

thanks a lot

[israrkhan]

can you please share a sample document,

will be easy to help you...

[sunny_talwar]

I just realized that you already have count as a field name and also did not see the last part where you need the sum for only 2012. I am working with your qvw file to figure out a solution.

Best,

S

[#6]

I attached a sample file and data file(XLS) in post 1.

tnx

[Peter_Cammaert · Accepted solution]

Is this OK?

I'm sure it can be done with a ValuieList() dimension as well. Then you won't need the extra INLINE table.

Good luck,

Peter