Problem regarding selection/unselection

[sarfaraz_sheikh]

Dear All,

I have 5 dimentional pivot table.When i click on 2nd level dimension then i will get all the associated data but the movement after i release the selection from 2nd level dimension then the selection is not releasing.

For more clarity have the look on attached snapshot.

belew snapshot is whithout selection on complaint

below is selected one ...once i selected over complain the movment after i will unselect the complain then it should be release as of now it is not happening.

Kindly help if any clue solution ......It is important.

My QVW is also attached here for your refernce.

Sarfaraz

[alexandros17]

The reason is because with your dimensions every time you select in the second column there is more tha one selections, take a look to the version I attached ...

Let me know

[sarfaraz_sheikh]

Dear Alessandro,

Still  i am facing same problem...kindly help !!!

Sarfaraz

[sarfaraz_sheikh]

I understood the problem....once once i click over dimension .,..more than one selection is happening...How i can remove the same ....

Sarfaraz

[alexandros17]

Move your dimension condition in the script creating a new field and use that field as your dimension

let me know

[sarfaraz_sheikh]

Dear Alessandro,

Great Solution...Thanks a lot as of now it is working fine ........However one more query to ask you

Can i obtain top 10 on the basis of classification master column wise...have look on below sbnapshot.

Sarfaraz

[alexandros17]

After dimension tab there is a "dimension Limit " tab, use it to show top 10 ...

Let me know  and ... if the answer is correct could you please mark it?

Thanks

[sarfaraz_sheikh]

Dear Alessandro,

In pivot table there is no dimension limit tab, on dimension tab .......Thats the reason i asked you

Safaraz