6 Replies Latest reply on Jun 15, 2016 10:40 AM by Dwight Taylor

# Adding Vertical Variance Columns with Measure Values in One Worksheet?

Is it possible to create the following visualization using "ONE" Worksheet?  The image below is four different Worksheets (say it ain't so)..  The Workbook is attached

V\$ = Is the difference between 2016 and 2015

V% = Is the % diff between 2016 and 2015

# The Current Single Worksheet View

PLEASE NOTE: Please disregard the static formula on the Columns shelf, it's there simply to add a label to the column.

Message was edited by: Dwight Taylor Updated image

• ###### 1. Re: Adding Vertical Variance Columns with Measure Values in One Worksheet?

Good Morning Dwight,

You should be able to drag other fields to the data area of the chart, then Tableau will title them automatically to match the field name. I took some variations on your data in your example to make a '2015' and '2016' and built the other calculations off of those. Getting the mark at the end of the chart is a little beyond my skill level at the moment, but color can be used pretty easily to offset the green/red. Jonathan Drummey made a "Floating Kpis dashboard" which might get the dots where you would like them.

I have no idea how to get a good link to a tableau public workbook. Everyone gets something so nice and short and stands out so well. Here goes:

http://public.tableau.com/views/floatingkpisforsupport/notalignedinDesktop?:embed=y&:display_count=yes&:showTabs=y

Hopefully, this works and helps. I don't have the best luck with links.

Happy Wednesday,

Chris

• ###### 2. Re: Adding Vertical Variance Columns with Measure Values in One Worksheet?

Hi Chris, the example on Tableau Public has Dimensions on Rows.  My Workbook has Measure Names on Rows, which is the way I need the View to be designed.  I think there's a significant diff between Dims on Rows and Measure Names.  Thanks for your assistance

• ###### 3. Re: Adding Vertical Variance Columns with Measure Values in One Worksheet?

Hey Dwight,

Is this more exact to your specifications?

I matched the formatting to your original specifications as well as I could. I think you'll be stuck with using multiple sheets unless you can reformat your data. There are a lot of other folks on here more skilled than I am with Crosstabs though.

• ###### 4. Re: Adding Vertical Variance Columns with Measure Values in One Worksheet?

Do me a huge favor Chris and remove the embedded image in Workbook you just posted and delete the image I originally included in the Post.  I replaced the image and I don't want others viewers of this post to see that image.  Thanks.  BTW, your suggestion is right along the lines of what I need, but reshaping the data isn't an option.  Great idea, I see you're an up and coming guru!

• ###### 5. Re: Adding Vertical Variance Columns with Measure Values in One Worksheet?

Image removed.

I think 'reshaping' the data might be simple depending on how you'd need to go about it. Tableau has a built in pivot option which might be useful in setting up the data in a fashion that you might need. That way, your original data remains unaltered. If you need the data in both formats, you should be able to connect to the same data twice and just modify the one to suit your needs.

• ###### 6. Re: Adding Vertical Variance Columns with Measure Values in One Worksheet?

Hey Chris, this has been a great exchange.  I'm talking with Tableau and let me say that there are two options available to accomplish what I want to do.  The first is the solution you provided, so I'm gonna give you that.  The second I'm getting from a guru "hidden under the stairs"...LOL within the walls of Tableau.  It's a really involved workaround, but it ultimate achieves the same result you achieved by reshaping the data.

1 of 1 people found this helpful