Pivot Table Grouping for only existent values

[tommyl]

Hello experts,

I need your help about below issue:

My data is like:

company	fileName	activityType	orderSum	campaignSum
A1	F1	C1	10	50
A2	F2	C2	14	32
A3	F3	C3	22	67
A4	F4	C4	15	8
A3	F3	C3	20	4

I want to create a pivot table with:

• dimensions:
  • company,
  • fileName
  • activityType
• measures:
  • sum(aggr(sum(orderSum),company,fileName,activityType)
  • sum(aggr(sum(campaignSum),company,fileName,activityType)

But the result is far ahead of my need as:

For Company A the result is as attached

(Same for the other Companies with related sums)

But what i need is : 

company	fileName	activityType	orderSum	campaignSum
A1	F1	C1	10	50
A2	F2	C2	14	32
A3	F3	C3	42	71
A4	F4	C4	15	8

I dont want zero valued unnecassry, notrelated rows to be displayed. Could you please help me how to do this? 

Thank you,

Regards,

Tommy

[tommyl]

Yeah, i was checking the data model, there was a sync problem. If i succeed i will check it like the way you expressed.

Thank you. 

[sunny_talwar]

No problem 🙂