10 Replies Latest reply on Jul 16, 2018 4:15 AM by Vijay Srikanth GVL

# How to do row wise comparison from a single data source

Hello experts,

I have one tde file which has the extract of current quarter information on a weekly basis something like below

In the database i have dimensions as Number, Stage, Close quarter etc. So the challenge here is to show the sum(\$ Value) for change in Stage for example on 2nd July Numbers 4 & 5 are in SS-04 but on 9th July they have changed their stage to SS-05 similarly Number 2 & 6 have moved from 2018-Q3 to 2018-Q4.

I have attached the excel file for your reference, would be great if anyone can guide me to achieve the results.

Regards,

Vijay

• ###### 1. Re: How to do row wise comparison from a single data source

Hi, Vijay

Not quite sure what's your expected result. can you explain when number 4,5,2,6 changes, what's your expected result?

ZZ

• ###### 2. Re: How to do row wise comparison from a single data source

Hi Zhang,

The expected result should be like it should compare both the time stamps at a Number level i.e., 2nd & 9th July in this case and give me the Sum(M\$ Value) where there has been a sales stage change or Quarter change.

Regards,

Vijay

• ###### 3. Re: How to do row wise comparison from a single data source

Hi Vijay,

My understanding is that you want to sum the values for Numbers 2, 4, 5 & 6 where there is a change in in Timestamp or Stage. However, you want to leave the values for 1, 3 and 7 unchanged. Is this what you want to achieve?

Ossai

• ###### 4. Re: How to do row wise comparison from a single data source

Hi Ossai,

I actually want to compare two dates in this case 2nd & 9th July which will give the status of Numbers in 2nd July as of 9th July.

In the above case for Opportunity 4 the sales stage has changed from SS-04 to SS-05 so i will have to tag them as Moved to a different stage or in case of Number 2 i need to tag them as Moved to next quarter.

Thanks

• ###### 5. Re: How to do row wise comparison from a single data source

Ok, so how would you want the answer presented? Can you show a screenshot of what the expected final results should be for each number from 1 to 7 in an Excel table format?

• ###### 6. Re: How to do row wise comparison from a single data source

Hi Ossai,

I wanted to represent something like below:

 Selected Date 2nd Jul Compared to Date 9th Jul Total value (\$ value) 15 Still in Same Quarter 8 Moved to 2018-Q4 7 Same Stage 11 Moved to different Stage 4

I am selecting current date as 2nd July and comparing it to 9th July based on Number field. For numbers 2 & 6 since they have changed the quarter from 2018-Q3 to 2018-Q4 i will have to represent the \$ value which has moved to 2018-Q4.

Similarly Numbers 4 & 5 have changed the stage from SS-04 to SS-05 so will have to show the \$ value of numbers still in the same stage and value of numbers moved to different stage.

Hope this clarifies.

Regards,

Vijay

• ###### 7. Re: How to do row wise comparison from a single data source

Hi, Vijay

Hope this helps

ZZ

1 of 1 people found this helpful
• ###### 8. Re: How to do row wise comparison from a single data source

Thank you Zhang, This is lot helpful and will suffice the need.

Also i wanted to check one more thing, the solution provided will work if i have only two quarters i.e., 2018-Q3 & 2018-Q4 but what if the data source has more quarters.

Regards,

Vijay

• ###### 9. Re: How to do row wise comparison from a single data source

Hi, Vijay

You are welcome.

To your question, since your case only has two days, selected date and compared to date, so my understanding is, for the same number, only two quarter at most will be involved in the calculation, others are filter out.

ZZ

• ###### 10. Re: How to do row wise comparison from a single data source

Thank you very much for your help Zhang..