Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone!
I have the next data:
type transactions client type2
1 3 name1 123
2 4 name2 234
3 11 name3 345
1 4 name4 133
......
There are a lot of types.
I create a pivot table with the dimension type and, for each one, i created a calculated dimension:
=IF(
aggr(
rank(
SUM(
{<
type2 = {'1*'}
>}
transactions
)
),type, client) <= 10,
client)
this bring to me the top ten client with the maximun transactions (in the expression I sum the transactions where type2 = {'1*'})
This is ok, but, i need another expression that sum all the transactions grouped by type (for the example data for the type 1 the sum is 7), i try with aggr, sum and total but it doesnt work.
Thanks a lot!!
Upload example!
May be this:
Aggr(NODISTINCT Sum({<type2 = {'1*'}>} transactions), type)
What is the expected O/P from given table
TYPE TOTAL TRX
1 7
2 0
3 0
Hi Juan,
Have you tried
Sum(TOTAL <type> transactions) ?
EDIT :Sum({$<type2 = {'1*'}>}TOTAL <type> transactions)
Kind regards
Andrew
It give me back the total for each client, not for each type
It doesnt work
I would have assumed effinty2112's expression to have worked, would you be able to provide a sample to show where it isn't working for you?
AGGR(Sum({$<type2 = {'1*'}>}TOTAL transactions),Type)
it dosnt work, i need it in every row
May be this:
Aggr(NODISTINCT Sum({<type2 = {'1*'}>} transactions), type)