7 Replies Latest reply on Sep 19, 2016 7:39 AM by emma.villarreal

# Help with a sum (Data Blending)

Good afternoon I have a question, how can I transform this

into this

I only have Sku linked between data blending, and I just wanna keep the Id only, I am attaching my workbook

Up

• ###### 2. Re: Help with a sum (Data Blending)

Hi Emma,

One quick thing you can do is just to highlight all of your SKUs, and then click "Hide", as below:

and then unclick "Show Header" for SKUs, and it'll look as you want it to:

Hope this helps!

• ###### 3. Re: Help with a sum (Data Blending)

Wow thanks thats works , do u know how can I divide Costo por cantidad/ Price ?? the total ??  for example in the first to get 78.67/1290 =.06098?

• ###### 4. Re: Help with a sum (Data Blending)

Emma,

You can do this by creating another calculated field of exactly what you just said: costco por cantidad/Price.  This is where things get a little tricky.  You'll move the measure values field onto your text marks, deselect anything you don't want, and then drag the fields to be in the order you need.

That way you'll have Cost | Price | Calculated Ratio.

Edited:

I adjusted the calculation slightly - I'm using the ATTR of Price since it's an LOD.  Seems to work appropriately.  I don't know if you're using Tableau 10, but that's the version of the workbook that I've attached to show what I'm talking about.

Does that help?

-Ann-

• ###### 5. Re: Help with a sum (Data Blending)

Thanks for ur answer, thats what I was looking for just one question, I saw that the sum per product is not correct do u know why is that and how can I fix that???

• ###### 6. Re: Help with a sum (Data Blending)

Are you referring to the subtotal for Costo por cantidad?

I checked to make sure that the total is set to sum everything, but that adds up the price column, which wouldn't be right, and doesn't change the Costo por cantidad column.

I suspect it's something to do with your calculation, but I'm not sure what at this point.

1 of 1 people found this helpful
• ###### 7. Re: Help with a sum (Data Blending)

Thanks I will try to see why is not working the sum or if anyone knows how to do it, thanks for ur help