Tableau: How to perform "Summarize totals except top 3"? -


i have data below name of person , total sales he/she made:

abc1    34 abc2    45 abc3    78 abc4    79 abc5    23 abc6    61 abc7    34 abc8    54 abc9    90

i have display dashboard below, top 3 sales guys , overall total sales made rest of team rot 498 - (90 + 78 + 79) = 251 team: 

abc9    90 abc4    79 abc3    78  rot    251

for top sales made, gave filter sales person name, limit condition "top 3". struggling display roi in separate worksheet. appreciated.

  1. right click on dimension [sales guy] , choose create/set
  2. define set top n (either hard code or use parameter change easily) , call [topnsalesguy]
  3. create calculated field [topnsalesguysplusother] formular: if [topnsalesguy] [sales guy] else 'rot' end
  4. use [topnsalesguysplusother] in table/graph , should have top n sales guys name , everythign else 'rot

Comments

Post a Comment

Popular posts from this blog

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

i getting "__type": "com.amazon.coral.service#serializationexception" as reply in postman & in test console in api gateway trying post record directly dynamodb using api proxy services.. referring aws article - https://aws.amazon.com/blogs/compute/using-amazon-api-gateway-as-a-proxy-for-dynamodb/ here's mapping { "tablename": "tablenamegoeshere", "item": { "id" : "$context.requestid" "eventname" : "$input.path('$.eventname')", "timestamp" : $input.path('$.timestamp'), "answers": "$util.parsejson($input.path('$.answers'))" } } update: did asked ... , worked if try add array of json objects gives me above same error - here's trying now. please - couldnt find on google well #set($inputroot = $input.path('$')) { "tablename": "answer", "item": {
Read more

asp.net - Problems sending emails from forum -

i have been redesigning site has message board, has been written guy looked after site. it has few problems , written in .asp , uses .mdb files database. you can see whole thing here . feel free post if helps, test thing have set using original files , new database. the basic problem when posts message, supposed email sent them, have posted it. when replies, originator supposed message, replier has been posted. i’d have thought @ point in process there should script/file in postmessage.asp? the postmessage.asp page below. <% option explicit %> <!-- #include virtual="common/adovbs.inc" --> <html> <head> <meta http-equiv="content-type" content="text/html; charset=windows-1252"> <meta name="generator" content="microsoft frontpage 4.0"> <meta name="progid" content="frontpage.editor.document"> <title>new page 2</title> <base target="_self"
Read more