Thank you so much! you really address my need.
I have to admit I'm a newbie with no programing background so if you don't mind, would you please so kind as to explain those to me?
1. how do you create "LAST()=0"? and put it up in Filter? I looked up at Analysis>Create Calculated Field but don't see it there.
2. is it possible to add one more "Profit Ratio" to "Sales" and get a bit refined description to list of subcategories?
e.g. instead of ,
can it changed to:
"Bookcases: 1% to $114,880 billions"
same for other subcategories.
(that 1% is its Profit Ratio, I made up the number)
I only know it's in "List of Sub-Category". But I'm still not good enough to write those codes (tried, but failed).
Thanks, again. really appreciate it.
I'd click Correct Answer but afraid of close thread.
Just one tiny detail: the [Sales] is set to Default Number Format as Currency with $ and billion, which show correctly on the first top arrow, how come the lower arrow has no thousand separator and $, billion?
Appreciate it, as usual.
Reason because we are converting number to string to append to the Sub categories,
In order to get the same O/P
Then we need a create a calculated field converting number to millions or billions as per the value
Hope this helps