Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following data:
Load * Inline [
ID,Desc,Pcode,Month
10,A,500,Jan
20,B,600,Jan
30,C,700,Jan
10,A,500,Feb
20,B,601,Feb
30,C,702,Feb
];
I want the output as below in a chart:
ID Desc Pcode Month
20 B 601 Feb
30 C 701 Feb
Logic: Show all the rows if the Pcode of Jan of an ID is not equal to Pcode of Feb for the same ID. In my output I am not getting the ID 10, because the Pcode is the same in both Jan and Feb. I do not have access to the script, so I need the solution in the front end using Set Analysis etc.,
Thanks for your time...
May be this
=Aggr(If(Pcode <> Above(Pcode) and ID = Above(ID), Pcode), ID, Month)
The output should be as below and sorry for the typo:
ID Desc Pcode Month
20 B 601 Feb
30 C 702 Feb
Thanks
May be this
=Aggr(If(Pcode <> Above(Pcode) and ID = Above(ID), Pcode), ID, Month)
Sunny,
Thank you and a quick question. I have almost 30 dimensions, is there any better way or I should use only Aggr() function ?
Thanks
I am not sure how those dimensions are and what you need the final output as... but more likely then not you will need an Aggr() function... although if the sorting is correct... you might be able to use just this
If(Pcode <> Above(Pcode) and ID = Above(ID), Pcode)