level of details (pivot)

[ilanbaruch]

hi all,

i have a model to measure campaigns, i have cost value of the campaign  level.

but 'under' campaign  i have lower hierarchy like countries, users etc.

when i build a pivot table i can see the cost (sum(cost)) only in one line for the campaign and all the drill down dimensions retrieve 0/null

any ideas?

advanced thanks

[sunny_talwar]

Seems like a data model issue. Would you be able to share your application or snapshots?

[ilanbaruch]

Hi Sunny,

maybe i can describe it better,

i have cost in campaign level so in a pivot i can sum(cost) and count users with a user create flag sum(create_flag)  this is how it looks like +-

Campaign	Users#	SUM(cost)
AAA	50	100$
BBB	80	144$
CCC	120	180$

i want to see it (cost) in user level like this:

CAMPAIGN	USER	COST
AAA	111	2$
AAA	222	2$
AAA	333	2$
AAA	444	2$
BBB	213	1.8$
BBB	323	1.8$
BBB	432	1.8$
BBB	123	1.8$

[jonathandienst]

With CAMPAIGN and USER as dimensions, use the expression:

     Sum(COST) / Count(TOTAL <CAMPAIGN> USER)