With your workbook open and displaying superstore (and the Superstore data source), in the Data window, right click State, Create > Set ; Create a Set State Set, select California and Colorado; Create a calculated field by selecting Analysis > Create Calculated Field. Here are the 7 major steps for putting this together: Set up your primary (main) and secondary (parameter) data sources. In the Calculated Field dialog box that opens, enter a name for the field. to another account. This is one of the most common Tableau errors that users run into, and it’s very simple to solve. There are 2 data sets (for this example, there is 1 column, and they are the same field). Change the default sort order of the field using the various options, and then click OK. Hi All, I have expected file results and actual file results tables in two different databases, (linking is not allowed), and I am blending these two data sources to get the data from these 2 tables. So you wouldn't be able to compare the dates from rows of Something and the dates of rows from Dim_Date. In the formula field, create a calculated field similar to the following: SUM([Profit])You can also solve this using data blending. 1 or later you can avoid the need for the custom calculation and use the two pass. By default Tableau Desktop wraps fields from a secondary data source in an aggregation in calculated fields. Filter Out Null Values. We need to do step "Under List of values, click Add from Field, and then select Coffee Chain Extract > State. The target field on any given worksheet is a field from another data source that is. This can affect the data included in the blend tables and change the output of the blend. Thanks, Adrian. A row in one source is unrelated to a. Hi there! I am using two data sources that must be blended and I want to create a calculation on the maximum date of the primary source. This formula computes the running sum of sales across the entire waterfall chart, ensuring it always lines up at the top of the highlighted. [My State])= ATTR([State]) THEN "X" ELSE "Y" END. ”. When finished, click OK. The actual data set I use is huge and a join is too slow. Since we are not sure of what the source is, you may want to start from the non-calculated fields first and keep adding to. One solution we have is to include "Region" column in DB apart from "Biz Region", based on which we can swap the column. This article describes how to create and use calculated fields in Tableau using an example. Environment. a)) x MAX (secondary. Let’s begin with what it is: the ATTR() function is for the aggregation of dimensions to turn them into measures. But since it is a blened data source, i can't use LODs. The new metric will be added to the blended chart. Step 5 – Drop the Total Sales measure onto the data area. The data appears as if from one source. Unknown file type Blend-test2. (This will not work on calculated field's that have been created in Tableau). Expand Post. Optimizing performance. Some examples include: cookies used for remarketing, or interest-based advertising. Union combines the data vertically, concatenating the rows from multiple sources. Tableau provides Date Functions to deal with temporal data, like DAY, MONTH, and YEAR. "All fields in a level of details expression must come from the same data. I then create two calculated fields: 1) Event Duration within Period - This is the length of an event during the specified period length. Use a blend when: You want to combine measures or dimensions with the same meaning but different names in each table. In the custom SQL field or dialog box, copy and paste the UNION ALL query. The View Data window displays row level data at the correct level of detail, without replication, to make validation easier. You may need to use it when creating calculated fields across blended data sources, for example. With the extract, your workbook will point to the data extract and everything should remain the same. Typically, the ATTR() aggregation can be used to get row-level values from the blended field. Tableau Desktop; Data Blending; 2 Data Sources with Identical Data Structures; Answer. Here, you would still see 'Null'. I'm working on a requirement were using a FIXED LOD with blended data source. But by default they're the fields from the primary datasource. " manually every time. Option 2: Create a calculation for a more dynamic sort. 2. Too big. The two data sources are blended on a string value they have in common called "DB Name". Sales Order Placed? ZN comes from the sales order data source. No. Combining dimension values to create an additional dimension value. In the secondary data source, create a calculated field. Advertising cookies track activity across websites in order to understand a viewer’s interests, and. I created an additional calculated field called Weighted Average new with the formula: SUM ([ Average TOW Completion Age ]*[ Number of Cases ])/ TOTAL ( SUM ([ Number of Cases ])) computed using Table (Down), this means that its value are calculated respect the Grand Total of Number of cases. Open a new sheet and place Sales to columns, Ship Mode to rows, and Reference Line to details. I have two data sources, one with costs, the other with sales. The moment I add those other fields into the calculation it fails. Please check the attached workbook for details. doesn’t use table calcs or fields from another data source) and you’re on v8. I have instagram data across several google-doc worksheets; one tracks individual posts and their associated likes and comments, while one sheet tracks followers. Loading. 4. There are some potential work arounds, but they are limited and clunky. It appears that Window calculations are the answer. [tier] == 2 'Top Vendors' else 'Mid Vendors'. In the formula text box, type the ZN function, the SUM. The key is telling tableau which way to walk along the grid, and LOOKUP will dutifully go there. ExcelR offers an in-depth understanding of Tableau Desktop Associate Certification training for Tableau developers and complete Tableau Server training for Tableau administrators. a)="x" and ATTR(D2. The only filters that will remove values are data source filters and context filters. Place the linking field in all worksheets that the action filter affects. Process for Creating the Dynamic “Parameter”. From the Measures pane, drag Measure Values to Rows. If [event] = 'option1' then 100. It would allow each date field to be evaluated independently. b)) Actual behavior seen = SUM (SUM (primary. according to a representative at tableau, there is no solution to this problem at present, though they are looking to solve. Select Analysis > Create Calculated Field. In Tableau Desktop, connect to Superstore sample data. For issues with a computed sort, see Sort Options Not Available. Provide a name to the calculated field: Shipping Delay. The option to change the aggregation type of the grand total to something other than Automatic is grayed out. This will be the field we use to link to our secondary data source. Calculated fields are always saved in the workbook and you can see them in the . Data blending is a method for combining data from multiple sources. Tried dashboard action filter also to pass from primary data source to secondary data source. In a worksheet in Tableau, select Analysis > Create Calculated Field. When you try sort by a calculated field that uses blended data, the calculated field is not listed in the Field drop-down list of the Sort dialog box. Only data that is relevant to a viz is queried. Is it possible to label these data sources something like 'Current' and 'Previous' so that my calculated fields can refer to the labels rather than to the actual date-named data sources - something like: ATTR ( [Current]. Filter Data Across Multiple Data Sources - Tableau Filter Data Across Multiple Data Sources Applies to: Tableau Desktop While working with multiple data sources in a. We need to do step "Under List of values, click Add from Field, and then select Coffee Chain Extract > State. A calculated field is a formula that performs some action on one or more other fields in your data source. For Allowable Values, select List. On the Columns shelf, right-click Measure Names, select Filter, select the check. I solved this. 1 excel extract where I have the daily stock data of 1 one year. Filtering data from the other source seems to incur restrictions such as "All fields must be aqqreqate or constant when using table calculation functions or fields from multiple data sources. Calculated fields with an IF statement not working after replacing data source Hi everybody, I have a workbook using an Hyper extract. Expert instructors. (TABLE(across) tells tableau to do it on a row-by-row basis. Work across blended data sources. You will need a common column between the two tables in order to blend. The primary data source has: Google Play, iOS, Steam, XBOX. The output of a calculated field can then be displayed for. To solve, use a left join. Blending from a polygon-based map to an existing data source which uses 1-to-many joins. Hello Mo, Considering how Tableau blending works--basically as an aggregated subquery rolled up to the level of your related fields--you are stuck with needing all fields to be aggregated before being leveraged in a blended-data-source calculated field. Absolutely - if you just take out Location from the view, this will work. It also can be used to test a value to determine if there is more than one response returned. ; Drag the Region field to the Color shelf on the Marks card. You should be able to create a new local data extract that combines the multiple data sources in your current workbook, along with calculated fields. Hi All, I'm having problems with a calculated field using blended data. In the Calculated Field dialog box that opens, complete the following steps: In the Name text box, type Subset Labels. Select one, and you'll see the fields for that tadasource. Drag Measure Names to Columns. The view is setup like this: The Grandtotals for the View are not correct. 4. However, they don't work in the calculated fields as shown in the topic but also for the parameters. Create a user filter and map users to values manually. Option 2: Join tables that are in the same data source, instead of blending them. Select Analysis > Create Calculated Field. If it changes into the ‘fx’ icon then it means it is a chart specific calculated field: Step-5: Click on the ‘fx’ icon. The COUNTD Alternative example workbook uses Distinct Customers. items) as a string in a parameter and pass that to a second workbook. One is Insurance Policy data e. In this case, Tableau reads MAX (Block) as MAX (ROBO 1, ROBO 11) and chooses ROBO 11. Click OK to create the new concatenated field. Under List of Values, select Add from Field > Sample - Coffee Chain > State. The target field on any given worksheet is a field from another data source that is. I selected "Specific Dimensions", then checked on all the dimensions, and finally selected to restart every month. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. The solution to this was to blend this data on top of my primary to get all 400 chargers. Data Blending - Calculated Field. The other to get the Max month as and when the data source is updated. Also you might need to create a duplicate calculation and the % and convert it to Discrete and in that case it would be visible. I need to count distinct the number of IDs using the COUNTD() function, but every time I drag the ID field (from the secondary data source) it changes it to an ATTR() and I cannot count distinct an aggregated function. Course Description. If the 2 datasources have the same columns, you shouldn't need to re-pull the data. Tableau Public; Data Management; Advanced Management; Embedded Analytics. A datetime field may be converted to a date field using a calculation to remove the time portion. THEN MAX (Block)". Click the drop-down arrow on the Marks card and select Map. For example, you can blend data from different BigQuery tables—say customer information and order details—and visualize that information in a single Looker Studio table. Answer. Data blending is a way to combine data in Tableau. 2 Desktop Pro. This data is not captured every 15 minutes but is event triggered. I would like to see a ratio of the two, so I created the following calculated field: The above method is called data blending. For example, suppose you have two data sources that are related by the State and Date fields. You can use Tableau's own pivoting function. So you did answer my question, such that, to filter data from 2 different data sources based on date - create a parameter, then create calculated fields in both the data sources. Stacked bar chart with blended data. I have a parameter date that I use to be able to filter across both sources and to show last year's information and this year's information in the same view. CSS ErrorExtracting the data and connecting to that. But I changed it to TABLE(down). 2. e. Create a new field called “Total Google Reach ” . Set the value to true in your data source filters. Blending data lets you create charts, tables, and controls based on multiple data sources. In the calculated dialog box, complete the following steps: In the name box, enter State Filter. but i f i blend on for example a location id, the data gets duplicated as location id has multiple entries in the blended data. In each account, create a calculated field named [GA Account] hard-coded to the name you had in the. Which can be interpreted as "there is more than one value". a) x MAX (secondary. The other option is to add a min and max date to your primary data source. Instead of the sum of all sales per region, perhaps you want to also see the average sales per customer for each region. Both source fields and target fields appear on the Filter shelf in their respective worksheets. When you try sort by a calculated field that uses blended data, the calculated field is not listed in the Field drop-down list of the Sort dialog box. Calculated Field based on two data sources. A calculated field that itself has a table calculation and includes at least one calculated field with a table calculation. But since Tableau do not support create data, I cannot create individual dates from that range. Then drag Quarterend date to Rows, since we want financial data by date. Now, let’s go step by step and see how to use rank function in tableau. I create calculated field "Number of period" in many steps. If this aggregation is ATTR() then the grand totals may be blank. Tableau’s INDEX () function allows you to easily compute the number of weeks since opening. I knew there is a way as below link, but that way I have re-do all calculated fields which is really time consuming. On the Marks card, change the. In the Calculation Editor that opens, give the calculated field a name. The simplest way to think of data blending is as an aggregated outer join. In this example, the calculated field is named "Index". Also, if your calculated field is a regular aggregate (i. I am trying to use the below formula instead of countd function because my data comes from Impala. With nested table calculations, you can set Compute Using configurations for individual calculations independently. Parameter field could not be refreshed automatically, if underlying data is changed by tableau server scheduler. Some examples. Applies to: Tableau Cloud, Tableau Desktop, Tableau Server. It would look something like this: IF ATTR(D1. . Total aggregations cannot be applied to table calculations or fields from a secondary data source. A union in the tableau data source screen is 100% the best way to go. Drag the calculated field to the Color shelf on the Marks card to create a view that shows which fields match and which fields are different between the two data sources. Process for Creating the Dynamic “Parameter”. So the question here is the user comes to the Parent_child worksheet which uses first data source and clicks the parent, I populate Child set with all child associated with that parent selected using Worksheet Actions. Option 1: Use a separate bar for each dimension. The new calculated field is added to the Data pane with an = in front of the data type icon to indicate it's a calculated field. It. I would really appreciate some help with operations on a calculated field with multiple sources. 1. I created an additional calculated field called Weighted Average new with the formula: SUM ([ Average TOW Completion Age ]*[ Number of Cases ])/ TOTAL ( SUM ([ Number of Cases ])) computed using Table (Down), this means that its value are calculated respect the Grand Total of Number of cases. Loading. It displays the measure accurately within each color segment. Go to the arrow icon option in the top left corner. Normally, I'd do create a T/F filter with Year = Year as a calculated field, but when I go to set them equal to each other, the secondary data source shows up as an attribute (ATTR). Right-click the replacement calculation on the shelf, and select Edit Table Calculation. 4. Create 2 calculated fields one for the Month and Year to show it as a filter. Assignment Actual Work is a field from secondary data source. For * and Null values, the issue may lie in the data granularities and fields used in the report. How to use a field from Blended data source in FIXED LOD calculation? Why Tableau Toggle sub-navigation. The easiest way to implement this feature would be to do this like it's done with "Replace. So the question here is the user comes to the Parent_child worksheet which uses first data source and clicks the parent, I populate Child set with all child associated with that parent selected using Worksheet Actions. If you are looking at data from two disparate data sources, then you either need to join the data into one data source, or define the relationship within Tableau in order to use data blending. Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific. Exclude the NULL values. Then I will right-click Order ID and select Sort. My question is about blending data in Tableau desktop. Create a calculation field Diff. Is there any way to get a total in a field for secondary data source fiedl I have 2 data tables I am blending - both are tableau extracts. if actual run time falls in between expected start and end time, file is processed otherwise failed. Hello Folks,. Hiding unmatched nulls. Key Performance Indicator (KPI) Dashboards. Tableau data blending with calculated field There are rare situations where the requirement is to blend on a calculation, on a measure. data sources Filtering parameters Tableau Tableau Tips. My data source is an excel spreadsheet that consists of multiple stacked files. Some developers use this method as it looks more dynamic and immersive. There are some potential work arounds, but they are limited and clunky. You've ruled out data blending as an option, that could work as well. To concatenate in Tableau: Go to the Analysis menu and select Create Calculated Field. Hence, I decided to blend the data so that the amount aggregates to the date level of plan. We recommend using relationships as. The name of this calculated filed is 'MedEarnAndTotals'. [Sales Cycle])} THEN [PY Sales] ELSE 0 END That article mentioned this method works when "2 Data Sources with Identical Data Structures" which is not the case here. All calculated fields have equal signs (=) next to them in the Data pane. In the custom SQL field or dialog box, copy and paste the UNION ALL query. In the calculation dialog box, do the following: In the name text box, enter Sales for Store - South. Create an extract of the blended data source, and publish that extract to the server. so I would like to show a pie chart how many files are. If you have more complex calculated fields, then it can get even more complicated. One might wonder why an alias doesn't work in a calculated field or in a parameter while it works fine in a blending, an option to allow the user to choose the real value or the alias might improve the user experience. When you are in your calc field editor, you have a list of all your fields. Adding the pills to the columns and rows just alters the visualization, and adding the "last: True" filter ends up. I want to get a grand total of teh secondary data source column in a calculated field, just like we can use FIXED LOD to get the total same across each row. Option 2: Create a calculation using. Creating a calculated field for "SerialNo" or lets say Index(). Too slow; Filter across blended data sources filtering across data sources. Data blending brings in additional information from a secondary data source and displays it with data from the primary data source directly in the view. a) x MAX (secondary. Percent-of-total sales over time (Secondary Calculation) It's common to. [Target]) 3. I am using a calculated field to determine whether a STATE is X or Y: IF ATTR([Sheet1 (TableauTest2)]. Training includes 30 hours of hands-on exposure to ensure that you are left will a feeling of being an expert at the Tableau tool usage. Hi All, I have expected file results and actual file results tables in two different databases, (linking is not allowed), and I am blending these two data sources to get the data from these 2 tables. I tried having both the calculated fields in the same data sources and using the filter values applied to the data set within the same source but it is no use. That said, I'm not sure how I can then use this data to create labels on line chart that comes from the blended data. To filter out null values, click the null indicator in your visualization and select the ‘Filter Data’ option. I have a scenario in which I need to blend the data. Within same worksheet, you don't lose table calc settings unless you keep all fields in the table. A calculation editor pops up on the screen. Normally if i am using the same data source to calculate running sum of a measure ,I would create a calculated field using running sum function and go to the compute using-> advanced-> field and then select the measure and check the descending order button. Drag a dimension to Columns. Drag the "new union" pill into your data source pane and select the tables that you want to bring together, in this case DS 1 and DS 2. It can. A new window will appear on your. I blended data for category (Kategoria Produktowa Poziom 4). Tableau Desktop; Resolution Use one of the following workarounds:. Training includes 30 hours of hands-on exposure to ensure that you are left will a feeling of being an expert at the Tableau tool usage. Tableau Deep Dives are a loose collection of mini-series designed to give you an in-depth look into various features of Tableau Software. Replace the calculated field that references a field in secondary data source with calculated field created in step 2. Why Tableau Toggle sub-navigation. When you apply a filter to multiple data sources, you create a source field and one or more target fields. The inner IIF() is a row-level calculation that evaluates the In/Out of the Set, then that gets wrapped in MIN() because we’re working across the blend – Tableau requires us to aggregate all measures and dimensions used in calculated fields from other data sources. 0. I thought that I could write a new calculated field using field value from one data sources and field from another data. Data blending. Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. I created calculated field 'SO Placed?' in the account inquiry data source using the following: IF [Data (Sales Orders)]. For example, select Analysis > Create Calculated Field, and in the Formula text box, type the following formula: This will be ugly because one set of fields will all be NULL, but I think we can use some calculated fields to make this work. a) If the data source is a data table, you can do a self-left join on Column 1 from Column 2. In the Data pane, right-click the Top N Customers by Sales set, and then click Create Calculated Field. A datetime field may be converted to a date field using a calculation to remove the time portion. To edit a table calculation: Right-click the measure in the view with the table calculation applied to it and select Edit Table Calculation. The Example. If you create a quick filter on a field from data source 1 and apply this quick filter. i. When I created a calculated field to. When you apply a filter to multiple data sources, you create a source field and one or more target fields. That’s it. Click OK to close the Edit Group dialog box. In the calculation editor that opens, do the following: Name the calculated field, Running Sum of Profit. if actual run time falls in between expected start and end time, file is processed otherwise failed. Then the calculation is in the data source and available to other users of that data source. I wrote that I tried creating calculated measure (combining dimensions from the data sources) to use as a filter, but then I can't aggregate on my table properly. I appreciate the response! I suspect the issue is due to a logical layer being applied via relationships to the data sources. The PY Dataset contains a subset of those records (700 records which ALL exist in the CY dataset). I've tried using a combination of parameters and calculated fields to try and create a global filter such as explained on this VizWiz blog entry VizWiz: Create a global filter in Tableau across multiple data sources in eight simple steps - Data Visualization Done R…, however I was not successful on applying this method to a date filter. A blend merges the data from two sources into a single view. I have been struggling to come up with a way to fix the global average field while traversing through accounts in the quick filter (to show. Blending will "blend" them together into a single element. Ben I have a scenario in which I need to blend the data. Applies to: Tableau Cloud, Tableau Desktop, Tableau Public, Tableau Server. " manually every time. This says to take all the values within a month across the Category dimension. However, I am still having issues. Advertising cookies track activity across. DateRange (B as in Blend – you probably won’t use this field for anything else and the prefix helps you remember to use it) as [date] >= [Start Date] and [date]<= [End Date] logged in. I tried to achieve this by blending both the data source and creating calculated file, got some issue. Move each field into below position and change the type to "Line". In the Formula text box, type the following formula to create dynamic labels for the customers in the set:1) Created a view with Project ID & Date field on Rows. Data Blending - Calculated Field Hi, I have a workbook which contains a blended relationship between three data sources. Course Description. If Channel<> 'Video'. Right-click the parameter and then select Show Parameter Control. Create a new calculated field named date calculation. This post covers tips and tricks for working with relationships. Additionally, if one field is aggregated in a calculation, all others must be as well, so wrapping those fields with an ATTR() aggregation will. Select Analysis > Create Calculated Field. ×Sorry to interrupt. Hope this helps. You'll learn Tableau calculation concepts,. Then change the calculation type to discrete. Make this calculated field to discrete. That calculated field is graphed on a bar chart which has a field from the main data source on the color shelf. Enter the concatenation formula, for example, [FirstName] + [LastName]. Tbh, this can even turn more complex if you have a use case wherein the date is based on non calendar. According to the year, quarter, month, week, and day, you need a new calculated field to display the sales. If I have filter 'Category' and choose 'Furniture', the 'Sub-category' filter items on the dashboard are not reduced to show values relevant to only 'Furniture' category. Tableau will not disable calculations for these databases, but query errors are a. Row level calculations are by definition within the same data source. Cause Tableau Desktop cannot identify what information to use for the action filter if the field used for blending is not included in the views that are affected by the action filter. Data Blending - Calculated Field Hi, I have a workbook which contains a blended relationship between three data sources. is when Machine_Nr is not in the view of the sheet and I want a calculation similar to countd operation as a seperate calculated field because I will be using the above value in a different field. In short, this will act like a filter to the 'Data to Map to' sheet, and give only P07 data, as it the maximum value in the 'Sales Cycle' column. In this instance, I am controlling one data source from another. Create a “Blend Field” with a value of 1 in both your primary and secondary. If you have two very similar data sources each with dozens or hundreds of fields and for one you already created a huge amount of calculated fields, set and parameters, it would be great if you simply could copy and paste them to the other data source. Now you see a new group field listed in the Population data source (primary) called State (group). If I have: blended data with date as the linked field. Resources Toggle sub-navigation. Because I have to blend the 2 data sources it requires aggregation meaning when I create the sum like excel pivot I get this. I can create a result that shows, in one column, CNTD([StringField]) from the primary table, and in a 2nd column, SUM([Number of Records]) from the secondary table. Select the arrow icon and click on the "create a calculated field" option, as shown below. In the last two articles of this parameters Deep Dive, we’ve learned how to use parameters with filters and within calculated fields. Deploy your workbooks with dynamic parameters and never again think about manually updating your parameters with the latest data. I have a field called account and for each account, some KPIs are calculated. Showing Grand Totals with Blended Data | Tableau SoftwareData blending is a method for combining data from multiple sources. At its core, the function is performing the following test:. Step-2: How to create Table Calculation. Replace the calculated field that references a field in secondary data source with calculated field created in step 2. When I searched "Door ID" in data source 1, I was able to find some of the values. ; Drag. . To do this, I will drag the “Sort By” calculated field to the Detail Marks Card on my view. AccID - unique Acc ID. When you try sort by a calculated field that uses blended data, the calculated field is not listed in the Field drop-down list of the Sort dialog box. In the Open dialog box, find your Excel workbook, click the Open drop-down menu, and then select Open with Legacy Connection. Mark just true values; Now you are good to go :-) Best, - Hil This is what I did to create v1 of the attached. Work across blended data sources. Step 3: Next, create calculated fields in Tableau, as shown below. The concept of "row" is meaningless across two unrelated data sources. Tableau provides a set of predefined aggregations that are shown in the table. Download the data source to Tableau Desktop, create the calculations, then republish the data source. If you look at the Blocks tab (which is sorted by day and start time), a procedure starting at 1:11pm would fall in the ROBO 1 block, which started at 12:30pm. Click the link mark right to data field Sub-Category of the secondary data source Sheet1 (target) 2. Blend as normal - you'll only return 1 value per name from the. Tableau(Calculated Field) 0. The field I am linking on is ‘Order ID’, so I have called my field ‘Selected orders’ and written the calculation below. For example, I export a data dump of employees at the end of each month, and I stack that on top of the previous month end data dump report. If I have: blended data with date as the linked field. From the Data pane, under Measures, drag Sales to Text on the Marks card. How to filter on primary data source only in blended data chart. I've built a view with loan number from primary data source, and amount from the second data source. Note: the parameter belongs to the workbook and can be created from any data source (primary or secondary). The target field on any given worksheet is a field from another data source that is. In the example workbook, the calculated field is named Target. And the "show empty rows" selection is automatically greyed out when i blend data. So it will always be pulled into the calculated field as aggregated field and for that your 1st field needs to be an aggregate too because you can't the mix the two. In Tableau, data blending refers to the process of joining or linking data that resides in separate sources, such as databases, Excel files, or web services. This is hack-y, but it works: Create a calculated field based on the measure that would return the right alphanumeric sort, such as -SUM ( [Sales]) for a descending sum of Sales, then put that as a Discrete (blue) pill to the left of the dimension you want to sort, and finally turn off Show Headers for the -SUM ( [Sales]) header. Step 2: Create the table calculation. Step 1: Create the calculated field. I have a filter for Resource Manager-The totals were correct for the. "The calculated field I am nesting within the other calculated field has a value of: [Measure] = 'MedWg' AND [Characteristic] = 'Totals' . In v8, you can use that DB1 blending or the new "DB2" blending where A) the linking fields don't have to be in the view, instead you just click on the linking dimensions in the secondary in the Data Window, and B) you can control those linking dimensions on a per-worksheet basis. Right-click the replacement calculation on the shelf, and select Edit Table Calculation. Initially it seemed to work. Step 1 – create a set from the field you want to filter by The first thing to do is create a set from the field you want to filter by.