Pivot table- How do I break the column into 2 or more sub columns?

[Anonymous]

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.

[Anonymous]

Thanks for the info.

[Anonymous]

Hi, is this possible to sort this list by Patients Service revenue amount (decreasing )only for the year 2016. ?

[sunny_talwar]

Used the following sort expression and sort descending:

Sum({<%year = {$(=Max(%year))}>}%Revenue)

[Anonymous]

Awesome! That Works!

Thank you

Pavithra Shetty