4 Replies Latest reply on Jul 12, 2018 1:08 PM by Vidya Sagar Malla

# Show PIE Chart in Percent of Different calculated dimensional values

Hi,

I am a new bee. I have a simple requirement. From the below data I want to create a PIE chart. PIE chart should show 3 slices of Top Category AUM (Top 5 Products = 25%, Next 10 Products = 25% and The Rest = 50%). I know I a need to use some LOD in AUM rank but no luck. A help would be much appreciated.

Top Category AUM is a calculated column:

```Expression:
IF [AUM Rank]<= [topn] then 'Top '+STR([topn])+' Products'
ELSEIF [AUM Rank]> [topn] and [AUM Rank]<= [nextn]
THEN 'Next '+STR([nextn])+' Products'
else 'The Rest'
END
```

AUM Rank is also a calculated column:

```RANK(SUM([Total AUM]))
```

PIE Should look like this:

• ###### 1. Re: Show PIE Chart in Percent of Different calculated dimensional values

Hi Vidhya,

Create a pie chart with TopCategoryAUM and AUM

go to quick table calculation , select desired calculation which you need.

1 of 1 people found this helpful
• ###### 2. Re: Show PIE Chart in Percent of Different calculated dimensional values

Thanks for looking into this Anil. I guess this not that simple. The momemnt I uses the TopCategoryAUM pie is summing up to the AUM.

• ###### 3. Re: Show PIE Chart in Percent of Different calculated dimensional values

Can you attach the excel/csv file of this data?

• ###### 4. Re: Show PIE Chart in Percent of Different calculated dimensional values

Hi Anil,

Here is the brief information with the sample Phones data.

And here is what I want to achieve in Tableau.

• Rank has to be generated based upon the Product Subcategory and Product Name for each Product Category
• Rank Parameters: Now I have two Rank parameters
1. TopN: Contains drop-down values of 1,2,3,4,5,6
2. NextN: Contains drop-down values of 1,2,3,4,5,6
• TopCategroy: Now what I want to achieve is when I select 2 from TopN parameter Topcategorycalculated column should give me the string output  as Top 2 Products with SUM of the price for the first 2 products and when I select 4 from the NextN parameter Topcategorycalculated column should give me the string output as Next 2 to 4 Products with SUM of the Price for 3rd and 4th products.
• Ultimately I want to show them in a PIE chat just like the below image.

 Product   Category Product   Subcategory Product Name Price SmartPhones Apple Apple S10 \$         100 SmartPhones Samsung Samsung s7 Edge \$         200 SmartPhones Nokia Nokia 5120 \$         300 SmartPhones Nokia Nokia 9 \$         400 SmartPhones Sony Sony Xperia \$         500 SmartPhones Motorolla Moto Rock \$         600 Laptops Acer Acer Aspire R \$         700 Laptops Acer Acer Alpha \$         800 Laptops HP HP Specter \$         900 Laptops HP HP ENVY \$      1,000 Laptops Dell Dell Inspiron \$      1,100 Laptops Lenovo Lenovo Flex \$      1,200

I worked with many BI tools like Tibco Spotfire, Qlik , MicroSoft Power BI. I have acheived the same result with in no time. Since I am into this tool form last 2 days unfortunately I could not crack it.

Your help will be much appreciated.