Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Seems like a data model issue. Would you be able to share your application or snapshots?
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$ |
With CAMPAIGN and USER as dimensions, use the expression:
Sum(COST) / Count(TOTAL <CAMPAIGN> USER)