5 Replies Latest reply on Jun 20, 2017 8:17 AM by Zhouyi Zhang

# Get once value for the same suplier

Hi all;

I´m new in Tableau, I´m just learning about it.

In order to make clear, using the following example:

e.g.

SupplierPlanningDone
Supplier 1\$ 1,500,00\$ 300.00
Supplier 1\$ 1,500.00\$ 250.00
Supplier 1\$ 1,500.00\$ 1,000.00

Then, I need to get once value for Planning for the same supplier and summarize all was Done. It´d be like a comparison between Planning and Done, but I can´t do it.

I´ve tried to use {Fixed [Supplier]: Min [Planning], but it´s still summarizing it.

I´m gonna be so grateful if someone could help me.

• ###### 1. Re: Get once value for the same suplier

If I understand you correctly, {Fixed [Supplier]:MIN([Planning])} would give you \$1500 for Supplier 1 and if you want to Summarize Done then using {Fixed [Supplier]:SUM([Done])} would Return \$1550.

You can also Create a T/F Calculation and Drag it to Filter.

{Fixed [Supplier]:MIN([Planning])}={Fixed [Supplier]:SUM([Done])}

Thanks

Deepak

• ###### 2. Re: Get once value for the same suplier

Thanks Deepak, but it did´t work. Let me try to be more specific.

There´s a planing cost for that supplier that I supposed to use, but for this cost I have some splited values (they aren´t split equally)  which can or can´t be the same of a planning cost (as example above).

I´m not sure if FIXED function works at my table. When I use FIXED function and I have more than 1 supplier with the same planning cost, this function brings me summarize of planning cost for supply 1 and sometimes none cost of others suppliers are brought. The following example can be clearer.

However, I need the following planning cost:

Is there any way to do it?

Thanks!

• ###### 3. Re: Get once value for the same suplier

Hi, Frederico

I think Deepak's calculation is correct. What you need is for display purpose.

So I reuse Deepak's calculation but create a new calculation for you. Please find my solution below.

A sample workbook is attached.

ZZ

1 of 1 people found this helpful
• ###### 4. Re: Get once value for the same suplier

Thanks Zhouyi, you were very helpful.

I´ve already found where I was wrong.

Finally, I could achieve it.

Again, thanks all.