Hello everyone,
I have a spreadsheet with temperature records from several sensor loggers.
I need to find out how many sensorss have an average temperature above a certain value (temperature rounded down without decimals from [Temperature (int)] column).
I can calculate this using a combination of a pivot table and Excel formulas, but I can't create a calculated field or measure in the pivot table (PowerPivot) that would do this automatically and of course dynamically based on the filters and slicers used, as you can see in the attached file.
There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.
I am adding an attachment.
Notes:
The decimal separator is a comma.
The function separator is a semicolon.
I haven't been able yet to resolve the issue, though I could create a pivot table that identifies the sensors for each base value. See if this is something you can work with. If not, come back here and I or someone else can perhaps come up with a better solution.
Is this the kind of thing you wanted?
