dimension hiding in a chart

[rajtechnocraft]

Dear All,

How can i hide a particular dimension in a chart which could be pivot table /bar graph

what macro i should write

i went through api guide but couldn't find a suitable macro

I am using qlikview 9 SR1

Can anyone help me on this

I have to use pivot table only .

I know in straight table this can be done easily.

Help me !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!