Forum Discussion
Helper IShow Top N values in Table
Hi....I am trying to get top 1 of each Svc Code in the sample below table. I would like it show as a table. I can get the info into a slicer but it makes it look to busy with all the seperate slicers.
I would like the table to show the top 1 (FY17 TER) for each Svc Code.
Any suggestions would be greatly appreciated.
Thanks
Hi hkrash0920,
If you only want the 1st value you can add the Svc code to your table and on the FY17 TER select the summarize option Max this will give you the 1st value.
You you need to sum all the values you should add this measure:
Regards
MFelix
3 Replies
- MFelix
Super User
Hi hkrash0920,
If you only want the 1st value you can add the Svc code to your table and on the FY17 TER select the summarize option Max this will give you the 1st value.
You you need to sum all the values you should add this measure:
Regards
MFelix
hkrash0920Thanks MFleix...I don't see the measure.
Thanks
v-sihou-msftMicrosoft Employee
Make sure the FY17 TER column is numeric. Otherwise, you can't make max aggregation as MFelix suggested.
Regards,