Log In
Register
Home
New Member
October 30, 2013
Offline
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.
Moderators
January 31, 2022
Offline
There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.
New Member
October 30, 2013
Offline
I am adding an attachment.
Notes:
The decimal separator is a comma.
The function separator is a semicolon.
Moderators
January 31, 2022
Offline
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.
1 Guest(s)
