Selecting a single cell in a pivot chart rather than a row

[Newbie777]

Hello,

I've created a pivot chart visualization of headcount where the row header is month dimension and the column header is year dimension.  I want to be able to select any combination of month-year to be able to get the names of employees at any point, by using the pivot as a filter slicer.  However, at the moment, I can only select a row at a time, and not a cell (of intersection of row and column).  How can I change the setting so that I can select a cell and not just a row in a pivot table?  

Thank you very much for your help.

[rubenmarin]

Hi, selections are done in dimensions, and the cells are the measures, depending of what dimesnions are you using thre could be a workaround when you show a field but selctions are done in other field, like using aggr() or dual().

It would be better if you add an screenshot and post an example like: I want to select X in field Y when the user clicks...

[Newbie777]

Thanks a lot for your response.   I'd like to be able to select a single cell in the pivot chart below, rather than just a row, as other charts are linked to this chart and I'd be able to get the list of names of the employees at a particular point in time when a cell is selected.  I found out that  Vizlib pivot table has a capability to select a single cell from the pivot table like below, and I was using that today, but I don't know the reason it stopped working for a few hours and I wasn't sure if it was just due to one off maintenance or if this is a recurring problem and it is unstable for regular use, so I reverted back to the standard pivot table below. I also noticed that if I select a row and then a column later, the intersection cell can be filtered down, but I was expecting to be able to select a single cell by just one click rather than by two steps of row or column selection and then column or row selections.  

Thanks a lot for your help.

[rubenmarin]

Hi, I asumed that when you clicked on a cell on the default pivot table, dimensions rows and columns were selected like it was done on Qlikview, but I alredy tested and noted that I was wrong and it does nothing.

Vizlib extensions has an option to work that way, there should be a check to 'Allow Selection on Measure', I haven't tested myself but it's written in their help page. I suppose it's stable, but again, I haven't tested myself so I can't confirm that.

Also there is the possibility that the administrator has updated the server to a newer version and the  extensions are still in an old version and something has stopped working for a while.