I am trying to make a report and to show some data in a pie, but it doesn't work. I give you a sample, it will be easier to explain.
It is a production report. I have to count the number of TRAY_NO by station and by shift, in a period of time (as shown on the pivot table). Everything works well here. Then I would like to show the total for each station in a pie chart (on the right). My problem is if I use the count function, it counts for all the data, not only for the ones I display. So inside the pie chart I calculate 2 "variables" to make a set analysis in count(), but I have "All values below limit", whereas there are values in the pivot table. And you can check the data, I have values for that.
Any idea of how to proceed or how can I solve my problem?
Thank you for your answer. In fact it displays data, but it is supposed to have the same figures than those in the last total column in the pivot table just above (to be exact, the sum of the total for each station between labo_cd 2 and 6), and the figures are really different... So I think the expression isn't working actually ( I already have tried something like that, and I had the same problem).
