hi there ,
i want only one record that should be maximum one......please find the attachment photo(which is sheet 8) and i want maximum record because in sheet 7 0306 0037(191.67%) which must not exceed 48 records.please some one help.
5 Antworten
Are you trying to display the Max value of the mutliple values for each 30 minute increment? Or the sum of all values? Either way, you will need to select "Aggregate Measures" under Analysis.
If you need the sum, all you have to do is go to Analysis and check Aggregate Measures and you have your answer.
If you only want to display the largest value, just create a calculated field "BE kWh Max" using the formula:
Then your data will display one maximum value for each 30 minute increment:
Hope this helps!
-Graham
