0 Replies Latest reply on Dec 18, 2013 1:13 PM by Shailesh Bhaskaran

# Showing  top X number of items as well as items themselves which form say 40% of total cost for a month

Hi!,

I am still learning the ropes of tableau and wanted communities helping in solving one of the problems.

I have a table like below

 Item Name January Cost February Cost March Cost April Cost May Cost June Cost July Cost August Cost September Cost October Cost November Cost December Cost A1 \$3.11 \$4.73 \$4.71 \$6.49 \$4.42 \$5.55 \$4.80 \$5.30 \$6.54 \$0.00 \$0.00 \$0.00 A2 \$24.02 \$29.04 \$23.96 \$35.80 \$21.22 \$24.84 \$19.53 \$21.75 \$30.35 \$0.00 \$0.00 \$0.00 A3 \$23.53 \$29.16 \$23.37 \$35.64 \$21.52 \$25.24 \$19.57 \$21.85 \$30.40 \$0.00 \$0.00 \$0.00 A4 \$23.78 \$29.10 \$23.24 \$35.92 \$22.02 \$24.97 \$19.50 \$21.70 \$30.45 \$0.00 \$0.00 \$0.00 A5 \$23.73 \$29.21 \$23.49 \$35.54 \$21.78 \$24.79 \$19.53 \$21.88 \$30.20 \$0.00 \$0.00 \$0.00 A6 \$24.09 \$29.26 \$22.94 \$35.14 \$22.67 \$24.67 \$19.64 \$21.77 \$30.29 \$0.00 \$0.00 \$0.00 A7 \$24.22 \$29.44 \$23.82 \$35.81 \$21.90 \$24.35 \$19.57 \$21.83 \$30.11 \$0.00 \$0.00 \$0.00 A8 \$23.73 \$29.03 \$23.13 \$35.56 \$22.21 \$24.16 \$19.28 \$21.63 \$30.29 \$0.00 \$0.00 \$0.00 A9 \$23.43 \$28.86 \$22.84 \$36.30 \$21.89 \$24.26 \$19.28 \$21.78 \$30.21 \$0.00 \$0.00 \$0.00 A10 \$22.99 \$29.08 \$22.84 \$35.84 \$22.30 \$24.01 \$19.52 \$21.69 \$30.50 \$0.00 \$0.00 \$0.00 A11 \$23.74 \$28.86 \$23.77 \$35.52 \$21.98 \$24.23 \$19.34 \$21.70 \$30.50 \$0.00 \$0.00 \$0.00

I want to achieve the following:

a) Show the top X number of items which form 50% of the cost in a month for 12 months. The intent is to show that 10% of the items cost 50% of the cost every month of the year

b) Show the top X items which form 50% of the cost in a month for 12 months. The intent is to show that more or less same X items result in 50% of the cost every month of the year

I tried with Percentage of total (Running_Total(Sum(Monthly cost)) plotted against but did not find the representation appealing.

Any help will be highly appreciated

Regards