How to make a better way to do the subfield in dimension

[uacg0009]

Hi all,

I have data like:

the fourth column is what he bought before this purchase.

I just want to show like:

IF I choose ITEM=A in the listbox then show a chart like:

I just want to show how many vips bought what ITEM before they buy ITEM=A(in this example).

I hope you know what I want to calculate, I don't know whether there is a function to calculate that or some way to do the subfield.

If you have any question please tell me, thank you.

[#2]

my pleasure. One more step to work out what you want.

modify expression to Count({$<HISTORY_ITEM-={''}>}VIP), and uncheck show total.

[uacg0009]

Yes, I think it solves my problem, I think I just need to use subfield(HISTORY_ITEM,'+') without third parameter.

I think that is ok for me, I am doing test now. Thank you Dariusz.

[uacg0009]

OK, I will try it. Your script skill is very strong and I learnt a lot. Thank you Wenkun.

[#5]

So,

If you dont need more help, please make some answer as correct It will avoid that people who are trying to help here will be still working on your case.

regards

Darek

[uacg0009]

OK Sure