How can I display filtered value and grand total in the same sheet

0 votes

I have a data source which is a database table where I group the number of active customers by SalesOwner. enter image description here

What I want to do is filter my sheet using SalesOwner so that I can make a bar chart that contains one of SalesOwners together with the Grand Total. What happens as of now is that when I filter my data and select one SalesOwner, the Grand Total obviously shows the grand total of that one filter.

Is there a way around this? A bar chart with just one of SalesOwners and the total?

Jul 27, 2018 in Tableau by ffdfd
• 5,550 points
1,098 views

2 answers to this question.

+1 vote

You can create a fixed calculated field using {FIXED : COUNTD(wk_customer)}  this will give your required answer with sales owner his total and grand total.

FIXED calculations are applied before dimension filters.  

A better way to represent this chart is by using a percentage calculated field.

  1. Select Analysis > Create Calculated Field. Name the calculation Percent of Total, enter the following calculation, and click OK: 

    { FIXED [Segment], [Region] : SUM([wk_customer]) }/{ FIXED [COUNTD(salesowner)] : SUM([wk_customer]) }

  2. Right-click Percent of Total in the Measures pane and select Default Properties Number Format...> Percentage

  3. Place Percent of Total on Columns

  4. Place Region on Rows

  5. Place Segment on Color.

  6. Place Percent of Total on Label.

answered Sep 15, 2018 by Machdata
• 340 points
Thanks @Machdata..Appreciate your enthusiasm and contribution :)
0 votes

Hi Atul,

    You can use dual axis graph instead to show the comparison of a single filter variable to grand total.

 By first calculating the grand total by using calculated field.Then following create dual axis graph for grand total and salesowner.

I used a similar data model ,to show the dual axis graph for number of customers for a region (sales owner) over all regions( sales owners ). 

hope this helps you.

answered Feb 26, 2019 by Cherukuri
• 33,030 points

edited Feb 27, 2019 by Cherukuri

Related Questions In Tableau

0 votes
1 answer

How can I count the aggregate function in Tableau

Create two calculated fields one for 100's ...READ MORE

answered Apr 6, 2018 in Tableau by Atul
• 10,240 points
5,665 views
0 votes
1 answer

How can I calculate the median of sales price using 3 variables in Tableau

First let me clarify things for you. ...READ MORE

answered Apr 12, 2018 in Tableau by xyz
• 1,560 points
7,041 views
0 votes
2 answers

How can I add text in the centre of a Donut Chart ?

Hi, You can read this for creating a donut ...READ MORE

answered Apr 4, 2019 in Tableau by Cherukuri
• 33,030 points
12,140 views
0 votes
1 answer

How to add a story with same sheet with different parameters and filters added in tableau?

Hi Riya, Follow these steps to add sheets/dashboard ...READ MORE

answered Mar 22, 2019 in Tableau by Cherukuri
• 33,030 points
3,592 views
0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 30, 2018 in Tableau by QueenBee
• 1,820 points
4,048 views
0 votes
1 answer

How to create a global filter

Assuming you have created a dashboard already, ...READ MORE

answered Apr 13, 2018 in Tableau by QueenBee
• 1,820 points
1,480 views
0 votes
1 answer

How can I create a second sheet which is filtered to 8 days ago,

Following are the steps you can follow: Create ...READ MORE

answered Jul 11, 2018 in Tableau by ffdfd
• 5,550 points
891 views
0 votes
1 answer

How to filter/parameter for different date ranges

Steps: Create a parameter control that the users ...READ MORE

answered Jun 21, 2018 in Tableau by Atul
• 10,240 points
5,068 views
0 votes
1 answer

How to add grand totals of the bar in Stacked Bar in Tableau

Hi Grim, As you have used reference line ...READ MORE

answered Sep 24, 2018 in Tableau by Machdata
• 340 points
5,337 views
0 votes
1 answer

How to determine average per event by year?

Hi Roshan, Create a new calculated field (use ...READ MORE

answered Sep 25, 2018 in Tableau by Machdata
• 340 points
873 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP