I have a pivot table in Excel that I cannot get to sort from High to Low on the “amount”

In my pivot table there is one column labeled ‘Week’ and two values: ‘Sales and ‘KPI’. I would like to display ‘Sales’ for all weeks but show the ‘KPI’ only for the last week. Is there a way to achieve this without resorting to hiding columns?

Image sample

Image sample

Image sample

So it flattens my data but changes the order. How do I keep it from changing the order of the header. In other words, I want each number in that column to be listed first before moving on to the next column.

So in my spreadsheet i need to group data by weeks. Also there is a specific requirement to display weeks on graphs not in full format, but like this
11-17.03
Weeks on graph

https://screenrec.com/share/sGNRuvcx1h
This is a project I’ve just finished working on in Excel.
My pivot tables look just fine and I can filter data.
I just opened my excel file again and the pivot tables are not allowing me to filter. The filter options are not even there.
How do I fox this?

I rely on Excel pivot tables for quick data analysis. Recently I noticed that the Filter -> By label treats all columns in the pivot table as Date! For example previously, if the column had only text, when I was clicking on Filter -> By label I would see these filters:

I have sample data like below. When i try to make a pivot table with one summarisation filed(Sum). Its absolutely fine. See the screen shot. But When i try to add another summarisation field(Average) , it creates duplicates for each column. See the screenshot. I would like to see Average only once as it displays for Sum. Is this possible in Pivot table ?
enter image description here