Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm having an issue with a pivot table chart, with multiple employees:
I've written some expressions and checked them with the database, they all calculate the values properly, when a single row in the pivot table is selected, however if I deselect the said dimension, the results are changing without any apparent reason.
I've checked all the possible filters and the only one that is changing is whether the dimension is selected or not. Is this a bug? Am I missing something? I've attached the .qvw, hopefully you can help me figure it out.
For example, in case of Bovenegio, the expression [% Informazione Medica] should return 47.14, which it does if I select Bovenegio.
Include your dimensions in the Aggregate:
100*(Sum({<nome = {'Informazione Medica'},role = {'1','2'},macro_area_codice = {'nordOvest'}>} Aggr(RangeMin(1,Sum({<nome = {'Informazione Medica'},role = {'1','2'},macro_area_codice = {'nordOvest'}>} Fraction)),assign_date,macro_area_codice,Cognome,Nome))/[N° TOTALE GIORNI LAVORATIVI])
Which tab are we looking at?
Custom Report, table NW
I am not seeing any expression called % Informazione Medica
My bad, it's "%Giorni Informazione Medica "
Include your dimensions in the Aggregate:
100*(Sum({<nome = {'Informazione Medica'},role = {'1','2'},macro_area_codice = {'nordOvest'}>} Aggr(RangeMin(1,Sum({<nome = {'Informazione Medica'},role = {'1','2'},macro_area_codice = {'nordOvest'}>} Fraction)),assign_date,macro_area_codice,Cognome,Nome))/[N° TOTALE GIORNI LAVORATIVI])
Here's the fields you have to select in the multi-box
That was it, thanks!