Set Analysis in Pivot table

[Anonymous]

Hi All,

Can we use set analysis to read the value of the specific row ??

I mean if my rows dimension in table is KPI, can i get the value of the KPI2 using set analysis??

Please help

[sunny_talwar · Accepted solution]

Check now

[Anonymous]

Thank you so much for you time and patience Sunny.

[sunny_talwar]

No problem at all

[#5]

Hi Sunny,

Is there any way to sort these KPIs, as we want. For example Ratio should come below KPI1 ?

[sunny_talwar]

You can do this using match function for your sorting expression

[#7]

I have tried using Match(KPI,'KPI1','Ratio','KPI2'), this is not working as Ratio is not in KPIs list.

[sunny_talwar]

You need to use the complete dimension instead of just KPI

=Match(Pick(Dim, KPI, 'Ratio'), 'KP1','Ratio','KP2', 'KP3')

[#9]

Thank you Sunny. It is working as expected now

[sunny_talwar]

No problem

[Anonymous]

Hi Sunny,

I Have a list of projects with Start & End dates.

I have used a master calendar to break it down into WK & Year months etc.

Now on the Pivot chart, I want o display the whole lost on MonthYear & Week but starting from the current week.

Which means I am not interested in the past weeks on the project I am looking at.

I need to look at the MonthYear from July 2018 & present week.

Please can you help me.