/profile-content.jspa?filterID=contentstatus[published]&targetUser=39634 Recent content in Tableau Community Forums en Wed, 20 Jan 2016 18:47:57 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2016-01-20T18:47:57Z en https://community.tableau.com/thread/144283 <!-- [DocumentBodyStart:c530ac56-3322-4da1-8d34-aab06794c78f] --><div class="jive-rendered-content"><p>A calculated field contains aggregates such as SUM and AVG. The calculated field is noted as a measure. However, I want to now be able to use this calculated measure as a dimension.</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>So for instance:</p><p>Dimensions are:</p><p>Company Name</p><p>Postcode</p><p>etc</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Measures are:</p><p>Segmentation (calculated field that is built up by using SUM and AVG of other measures)</p><p>etc</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>If I pull the Company Name to a Row and then the Segmentation Measure, everything is fine.</p><p>However, I now want to remove the Company Name and only leave the Segmentation and show other measures against the Segmentations.</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>I would like to remove the calculations behind the Segmentation Measure and copy that in to a Dimension. Just like you do a Copy and then a Special Paste values only in Excel.</p></div><!-- [DocumentBodyEnd:c530ac56-3322-4da1-8d34-aab06794c78f] --> calculated_field dimensions_measures Wed, 20 Jan 2016 18:47:57 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/144283 2016-01-20T18:47:57Z 3 years 5 months ago 2 0