Disregard Dimension to show non-aggr values

[jduluc12]

Hi,

My data set looks like this

Vendor	Number	Item	Desc	Amount
Vendor_1	123		For ABC
Vendor_1	123	Item-1		100
Vendor_1	123	Item-2		200
Vendor_3	456		For DEF
Vendor_3	456	Item-2		200

And I need to build a pivot table like this

Dimension:

Vendor

Number

Item

Expression:

sum(Amount)

Desc

As you see that Desc is not available on the same row where Item is so it shows up empty.

Is there any way to show Desc for each Item on the row

Like as follows?

Vendor	Number	Item	Amount	Desc
Vendor_1	123	Item-1	100	For ABC
		Item-2	200	For ABC
Vendor_3	456	Item-2	200	For DEF

I tried using Only function with Total but it does work.

Thanks,

Jean

[jduluc12]

I can not change the load script

[jduluc12]

It does not for me when I check "Suppress when value is null" for item.

I need to select that option for Items

[sunny_talwar]

Can you update my sample to show what exactly are you doing?

[jduluc12]

Just check the "Suppress When Value is Null " for item and it stops showing the value for the desc.

I just tried in your sample.

[sunny_talwar · Accepted solution]

Try this

If(Sum(Amount) > 0, Aggr(NODISTINCT Desc, Vendor, Number))

or just this

Aggr(NODISTINCT Desc, Vendor, Number)

[jduluc12]

Here is the changed file.

[jduluc12]

Thanks That works!

You are awesome!!

[sunny_talwar]

Updated it... check attached