Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
- Create a variable to store the % calculations
* v% = 100*(aggr(sum(Qty),Invoice #)/sum(Qty)
- Add another expression and add the below as definition
sum(Qty)&' ('& v% &')'
- Untick Bar in the Data option
- Tick Value on Data points
Hope this makes sense.
I have a sample file on personal edition not sure if you can open this
Note: Please check fields names match with the field names on your file
Thanks and
Padma
please understand my question i want to use drill down .. and to show data firstly on monthwise dn after drill down it will show the data airline wise and its total % assosicated in month data.