SAP HANA DATA COMPARISON OF CALCULATION VIEW

[former_member1321230]

HI All,

I have one scenario in which i need to compare the data of one column.

for example:- I have one graphical CV in which i have one column ID. Now i want to compare the data of two ID.

ID item cost

A001 200

A002 300

i need to compare A001 with A002 to check item cost if changing or not.

it will show me data like

ID Item_Cost ID item_Cost

A001 200 A002 300

and also i need to use ID twice as input parameter.

[lenastodal]

Hi and welcome to the SAP Community!

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful) and share screenshots of what you've seen/done. The more details you provide, the more likely it is that members will be able to assist you.
Should you wish, you can still edit your question.
Finally, if you're hoping to connect with readers, please consider adding a picture to your profile as it encourages readers to respond to you. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS.

Best,
Lena
SAP Community Moderator

[former_member721329]

Hi Sumit Sharma, You can JOIN this view with itself like self join.

You can also to create another calculation view where you join in that calculation view.