Hi Akshada ,
try creating Drill down Dimension.
I had a Situation like this before in some other scenario
there we drilled down as
in your case i didnt understand 1st level
if it is anything liike share/range dimension
or else you can create a range dimension by giving range values i guess.
transaction Number( use appropriate dimension)
hope this might help you in some way .
Thanks for your comments.
I have created drill down dimensions and used them in charts many times but this time the problem is with data. Data is not so simple to get the desired output.
About the range, we can give range to columns like age or anything which we take from only one column but in this case we want to bucket it or give range based on 2 columns. This is my understanding for the given requirement.