Hi,
I am trying to sort a pivot but it does not properly work and I have spent hours on it. I sent a screenshot of my pivot.
As you can see my pivot is first sorting by Issuer2 in first column which I like. But then I am trying to ask him to sort by total (3rd column) within each Issuer2 which works for Issuer2=B but not Issuer2=C, do you have an idea?
I should have within Issuer2=C, C4 then C1, then C3 then C2.
i have Issuer2 and Bond name is Rows and average of Z/ModDur in values.
I am trying to sort a pivot but it does not properly work and I have spent hours on it. I sent a screenshot of my pivot.
As you can see my pivot is first sorting by Issuer2 in first column which I like. But then I am trying to ask him to sort by total (3rd column) within each Issuer2 which works for Issuer2=B but not Issuer2=C, do you have an idea?
I should have within Issuer2=C, C4 then C1, then C3 then C2.
i have Issuer2 and Bond name is Rows and average of Z/ModDur in values.
