Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I can not change the load script
It does not for me when I check "Suppress when value is null" for item.
I need to select that option for Items
Can you update my sample to show what exactly are you doing?
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.
Try this
If(Sum(Amount) > 0, Aggr(NODISTINCT Desc, Vendor, Number))
or just this
Aggr(NODISTINCT Desc, Vendor, Number)
Here is the changed file.
Thanks That works!
You are awesome!!
Updated it... check attached