removing duplicate values from pivot table

[vijetas42]

Hi All,

I have below scenario in which i need to values should show in my pivot table only once if it gets repeated with respect to vendor.Please suggest.

Project	Vendor	docno.	Value	expected output
A121	V1	d1010	134	134
	V1	d1020	134	0
	V2	e1010	137	137
	V3	e1011	136	136
	V3	d1022	136	0
	V3	d1023	132	132

Thanks!

[devarasu07]

Hi,

Based on you data, when we use pivot chart object by default it should give you the desired output. what is the issue. can you elabrate more (i.e share like source data, current & expected output) tks

[avinashelite]

What is the logic your using to determine the value ? how your basing the uniqueness , on which columns

[vijetas42]

uniqueness of value should be based on column vendor

[vijetas42]

Please see the screenshot where I have mentioned the expected output should be like for duplicate it should consider 0

[devarasu07]

How you derive the Value measure? in your screen shot DocNo is unique field and if we apply your suggested rule then the last row (V3   d1023    132 as expected output?

[avinashelite]

If its on the vendor ..then you have mentioned 2 values for V3, which is wrong rite ? could you re-check again give us the logic

[parthesh]

I think in script you have to handle this..

Please find below demo for this... hope this will help..

Temp:

LOAD * Inline [

Name,Value

V1,10

V1,20

V1,30

V2,1000

V2,20

V2,30

V3,10232

V3,20

V3,30

];

Temp2: 

Load 

Name, 

Value,  

if(Name = Previous(Name),0,Value) as NewValue  

Resident Temp ;

Drop Table Temp;