Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Pivot table with Provider name, their revenue and year. I want revenue to be split into years.
For example My table looks like this:
I want above table (Patient Service Revenue column) look like this:
I have attached example chart also.
Thanks for the info.
Hi, is this possible to sort this list by Patients Service revenue amount (decreasing )only for the year 2016. ?
Used the following sort expression and sort descending:
Sum({<%year = {$(=Max(%year))}>}%Revenue)
Awesome! That Works!
Thank you
Pavithra Shetty