Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear,
I'm a bit puzzled on how to insert extra information into a pivot table in 2 extra columns. The 'surocc' and 'relevés' would need to be integrated in a column in the pivot table.
1)Surocc shows the total number of dates a value of 100 or more has been recorded for a given train (surocc)
2) count the total number of dates/days there is a measure for each train.(relevés)
Selection of the period may vary, so I cannot pre-calculate it. I don't see how it's done, and all my efforts so far lead to an 'error' in the pivot. Can anyone please share a solution?
Kind regards,
Johan
The Aggr function did the job in the meantime.
The Aggr function did the job in the meantime.