How To Avoid Synthetic Key

[vengadeshpalani]

Hi all,

i have source table as shown below

My expected Result should be

I have achieved this but I've got some synthetic keys in it. Could anyone say how to avoid these synthetic keys and improve the script?

[sunny_talwar]

Check attached

[vengadeshpalani]

Thank you Sunny. But my actual requirement is when I select C1 from "selectcustomer",  C1 should not appear in bar chart. But I need to achieve it only by script.

If we exclude the selecting customer, we can reduce number of rows in data model.

[sunny_talwar · Accepted solution]

Check now