Hi Koushik try to use to fixed LOD calculation so that quantity and difference column would not be aggregated before multiplication
hope this will work
I tried taking FIXEd..but unable to get the proper Value.
Not sure this will work or not? I haven't validated this calculated field.
Compute using Table (down)
Mahfooj i will try to implement thanks for your reply
Let me know If it works
Whenever you've such requirement where you've do some complex calculation then try to split your calculation in small-small results. Like in your case first try to calculated the Profit for Books and Cases separately and validate on canvas check correct output is coming or not. If you're getting correct then you're on right path
Once done then get the difference. Then after multiply with quantity. Then sum it up using WINDOW(). I alway follow this method and it works.
Its not working
I don't have tableau access right now else I must answer with correct calculation.
Are you able to calculated Profit for Books and Cases separately?
Split the calculations and check till get
What this calculated field is returnning?
Diff*Qty: [Diff]*sum([Qty]) //I've doubt at Qty
Or we've to take help from LODs
Do you've any other field on rows? Books/Cases values from on field right?
Can you show me exact format of your original data set? How it looks?