Forum Discussion
LisaB
Helper III
Helper IIIAverage on distinct values + filter
Hi, I would like to calculate the average value based on distinct values. However, it seems like my filters on page level messes things up: Filters: Status = Active, Item No: 100||200||300 ...
LisaBHelper III
Helper IIIHi v-yuta-msft ,
thank you for the clarification.
I don't think this formula will work for this case since there might be contracts when there is an active contract that does not include any of the ARR items. It might also be an inactive contract that include an ARR item. So only taking the first item (rank =1) will give the incorrect result.
Lisa
LisaBHelper III
Helper IIIHi,
I have attached an example file showing my report.
I wish to show the average based on the page and report level filters. However, I would the average value to change if filtering by clicking on a bar in the chart.
Hope this clarifies.
Thank you.
Lisa