To follow along with the steps in this article, connect to the Sample-Superstore saved data source and navigate to Sheet 1. Step 2: Click on “Add metric”. To calculate: 1. Resources Toggle sub-navigation. Go to the arrow icon option in the top left corner. Comparing Matching and Non-Matching Records Across Blended Data Sources Following the calculated field way described in Knowledge base works fine if the individual columns are added to the sheet . g. The percentages are calculated with the Sales measure aggregated as a summation, and are based on the entire table. If I blend my data, create a dashboard with data visualized from both the blended sources, I expect to be able to set a global filter on the linked field(s) of the blended data. A row in one source is unrelated to a row in the. The new metric will be added to the blended chart. 0. 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. Deploy your workbooks with dynamic parameters and never again think about manually updating your parameters with the latest data. In the last two articles of this parameters Deep Dive, we’ve learned how to use parameters with filters and within calculated fields. 2. Tableau’s answer to this situation is the blended calculation, in which fields from more than one data source can be used in a single calculated field. Just exclude it, and use the parameter to filter for the values. Exclude the NULL values. When you are in your calc field editor, you have a list of all your fields. In Tableau Desktop, connect to Superstore sample data. Hope this helps. ×Sorry to interrupt. A new window will appear on your. 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. 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. 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. A join will show rows for every match. Any thoughts on ways round this would be much appreciated. doesn’t use table calcs or fields from another data source) and you’re on v8. Option 1: Join the data sources with a cross-database join instead of blending. {FIXED [Machine Nr] : COUNT ( [Machine Nr] )} / {FIXED [Machine Nr] : COUNT ( [Machine Nr] )} This works fine when there is no secondary data source but when I blend with a secondary data source it grays. Note: The primary data source is indicated with a blue check mark, any secondary data sources and fields from secondary data sources have an orange check mark. In the Data pane, select the State data source (secondary). Rolled Over from - Contains the AccID if the account is rolled over from an older account. If you select a sheet in the dashboard, Explain Data analyzes the. Data blending is a way to combine data in Tableau. To calculate: 1. Then I have a calculated measure field with the formula SUM(DS1 Measure) + If ATTR(Structure) = "Description. For issues with a computed sort, see Sort Options Not Available. Just create a parameter with data type as a date then create a calculated field like this: [Parameter Date] = [Date]. The data for each table in a blend is queried before that data is joined into the final blend. My data source is an excel spreadsheet that consists of multiple stacked files. Additional Information While replacing ATTR() with MIN() will cause "Automatic" grand totals to show, the grand totals might not be the expected values. 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). CSS Error1. Right-click the replacement calculation on the shelf, and select Edit Table Calculation. 85-95% of target may equal Bronze, 95-105% may be Silver, etc. Within same worksheet, you don't lose table calc settings unless you keep all fields in the table. Tableau Calculated fields with data blending. The View Data window displays row level data at the correct level of detail, without replication, to make validation easier. When using a single data set everything on the view is represented by a single VizQl query. Calculated fields are always saved in the workbook and you can see them in the . Right-click the replacement calculation on the shelf, and select Edit Table Calculation. [Sales Order Placed? ZN] = 0. But I changed it to TABLE(down). Create the new field by adding Impressions + Total Views. Below is an example of using Attribute in a table calculation. Use a blend when: You want to combine measures or dimensions with the same meaning but different names in each table. a) If the data source is a data table, you can do a self-left join on Column 1 from Column 2. Doesn't work as this means that there is a one to many relationship for multiple fields, meaning that just a * is displayed; Generate lists of (e. Then the calculation is in the data source and available to other users of that data source. Then drag Quarterend date to Rows, since we want financial data by date. For this method, a Dashboard Action will be used to Filter across sources. " It seems like conceptually, one would want to have calculated fields that are independent of any data source (because they are independent of data) and. Next, drag Category from the Orders data source onto the view, then select the Orders data source and click the chain icon to blend on Order ID. [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. Now if you are asking to total across rows, well that's a different story and will take the type of new calculated fields like above - so would be a pain ** Robin, The ZN function will not work because of the data blending. Step-3: What we have made. I still can't fathom why tableau doesn't have the solution for this case - For example Max(1,3,5) as 5 and use the same 5 in if condition as mentioned below. That calculated field is graphed on a bar chart which has a field from the main data source on the color shelf. The two data sources are blended on a string value they have in common called "DB Name". Complication(s): Data is spread across different tables in different databases (biggest motivation to use Tableau, in fact). ×Sorry to interrupt. 5. Sales Order Placed? ZN comes from the sales order data source. The simplest way to achieve row-level security in Tableau is through a user filter where you manually map users to values. In the calculated dialog box, complete the following steps: In the name box, enter State Filter. IF calculation with aggregate functions. Data Blending - Calculated Field Hi, I have a workbook which contains a blended relationship between three data sources. Ali. Course Description. Absolutely - if you just take out Location from the view, this will work. Right now I need to update each calculated field to find variation from previous data file. The option to change the aggregation type of the grand total to something other than Automatic is grayed out. b)) Actual behavior seen = SUM (SUM (primary. The data appears as if from one source. I hope that somebody can help. Tableau Calculated field (can't mix aggregate - non aggregate functions)Applies to: Tableau Cloud, Tableau Desktop, Tableau Server. You can think of this as a union. LOD calculation and blended data sources. In the Table Calculation dialog box that appears, make your changes. 2) As they mentioned in the solution, it is not production complaint. I have blended the data on 'Account Number'. Problem is summarizing that up. All the dimensions are from DS1. It displays the measure accurately within each color segment. shin - while your solution solves the problem for the blended data, it introduces a problem for the pivot data (NAICS code, hoovers industry, and company name); i am now getting 'asterisks' in those tag clouds. Has been rolled over: A binary field that is true if an account has been rolled over. For Data Type, select String. Drag Measure Names to Color on the Marks card. The output of a calculated field can then be displayed for. 4. create new columns in) the extract. Understanding constants in a multi-table world. And the "show empty rows" selection is automatically greyed out when i blend data. The solution to this was to blend this data on top of my primary to get all 400 chargers. What I want is to calculate via a calculated field the number of times when the stock is out of boundaries. If your data is from same source then tableau has inbuilt feature to join your data. Select Analysis > Create Calculated. When I put category on either the row or column shelf I am getting the erro r "Cannot blend the secondary data source because one or more field use an unsupported aggregation". . Advertising cookies track activity across websites in order to understand a viewer’s interests, and. Option 2: Create a calculation using WINDOW_SUM () Drag the linking field (s) from the secondary data source to Details on the Marks card. Prep will retain the calculated fields. In the worksheet view you see the both tables: earnings and prices. I blended two data sources by Year. Data blending has been around for a long time – it was there before the Google Analytics connection. Create an extract of the blended data source, and publish that extract to the server. For example, type SUM([COGS]). Step-2: Select the chart whose calculated field data type you want to change: Step-3: Find your calculated field in the properties panel: Step-4: Hover your mouse over the ‘AUT’ symbol. It is necessary to know which dimension in the data source is unique for each row value, or the combination of dimensions. The moment I add those other fields into the calculation it fails. When you apply a filter to multiple data sources, you create a source field and one or more target fields. Tableau data blending with calculated field There are rare situations where the requirement is to blend on a calculation, on a measure. 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. While blending a secondary source, you are blending the second source thats post-aggregated and the results will be grouped based on dimension that is being joined. You can either use a cross database join to make a new data source drawn from the original two sources, or use data blending to combine aggregate results. For that you should have at least tableau desktop v10 or above. ThomasData blending is a very useful tool, but there are some effects on performance and functionality. Additionally, if one field is aggregated in a calculation, all others must be as well, so wrapping those fields with an ATTR() aggregation will. 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. When you apply a filter to multiple data sources, you create a source field and one or more target fields. IF "Retailer Group" == "Date_start" THEN DATE ("1/1/2012")Data Blending - Calculated field. In the Calculation Editor that opens, do the following: Enter a name for the calculated field. Blending from a polygon-based map to an existing data source which uses 1-to-many joins. Some examples include: cookies used for remarketing, or interest-based advertising. Option 1: Use a separate bar for each dimension. In the following example, the Market Share calculated field is not listed in the Field drop-down list. In my primary, I define another calculated field to do the aggregation for each project by tier: VendorClass: if max [Secondary]. a) x MAX (secondary. In the Data pane, select the Store - North data source. Some examples include: cookies used for remarketing, or interest-based advertising. Option 1: Use a separate bar for each dimension. 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. Format the date show that is shows the full date. Thanks, June 2, 2016. 0” in. i. " manually every time. Step 1: Create the calculated field. Step 2: Create a Set and use it in a calculated field. Ben I have a scenario in which I need to blend the data. to another account. Hello everyone, I am working on the accounts data of a certain financial institution. Then change the calculation type to discrete. . Percent-of-total sales over time (Secondary Calculation) It's common to. You can also set the aggregation for a field already in the view. When one of the data sources that you're working with is large, you can reduce query time by using data blending to combine data in the primary data source with summary data. Here are the 7 major steps for putting this together: Set up your primary (main) and secondary (parameter) data sources. The secondary data source only has: Google Play, iOS. Key Performance Indicator (KPI) Dashboards. A calculated field that itself has a table calculation and includes at least one calculated field with a table calculation. Above that list is a pulldown of all your other datasources. The two data sources are blended on a string value they have in common called "DB Name". A datetime field may be converted to a date field using a calculation to remove the time portion. At that point the calculations only exist in that workbook and aren't available in the data source. Tableau Deep Dives are a loose collection of mini-series designed to give you an in-depth look into various features of Tableau Software. data sources Filtering parameters Tableau Tableau Tips. 2 Answers. A filter just to match the LOD Max month with the regular months . Hope this helps. If I have: blended data with date as the linked field. 2 Desktop Pro. 1. e. I solved this. This will be the field we use to link to our secondary data source. I have a workbook which contains a blended relationship between three data sources. Select the arrow icon and click on the "create a calculated field" option, as shown below. You may need to use it when creating calculated fields across blended data sources, for example. Both source fields and target fields appear on the Filter shelf in their respective worksheets. Tableau Data Management. I then intended to blend on number of events. total). Step-2: How to create Table Calculation. Two other things: The ,0,IIF(FIRST()==0,LAST(),0) optimization is not needed if you’re using Tableau v8 or later. Mark just true values; Now you are good to go :-) Best, - Hil This is what I did to create v1 of the attached. Data Blending - Calculated Field Hi, I have a workbook which contains a blended relationship between three data sources. From the Data pane, under Measures, drag Sales to Text on the Marks card. 0. For example, the view shows the difference in average regional sales between quarters. Tried dashboard action filter also to pass from primary data source to secondary data source. 2. co as a source. Create a new calculated field named date calculation. Select Analysis > Create Calculated Field. CSS ErrorThe data set considered here has information regarding order date and ship date for four different regions. If you create a quick filter on a field from data source 1 and apply this quick filter. 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. Then it will not blend. In this case, Tableau reads MAX (Block) as MAX (ROBO 1, ROBO 11) and chooses ROBO 11. Step 5 – Drop the Total Sales measure onto the data area. The DS1 field is supposed be under Description A1 and the DS2 field will be under Description B2, although Description B2 also has data in DS1 (DS1 data for description B2 will not be used in this viz). The simplest way to achieve row-level security in Tableau is through a user filter where you manually map users to values. In this example, the field is called, Discount Ratio. The automatic grand total is incorrect: it shows. We need to do step "Under List of values, click Add from Field, and then select Coffee Chain Extract > State. 3. This article will guide you through the process of concatenating. Name the new calculated field to your preference. 3) Tableau pads the data to fill in the missing dates. One is Insurance Policy data e. 3. b) Expected subtotal method = SUM (SUM (primary. Has been rolled over: A binary field that is true if an account has been rolled over. Thanks, Adrian. ) with the column on the right (% population). I am blending these two data sources considering Datasource A as primary. See Troubleshoot Data Blending to learn more about the asterisk. You can either use a cross database join to make a new data source drawn from the original two sources, or use data blending to combine aggregate results. Tableau will not disable calculations for these databases, but query errors are a. How to filter on primary data source only in blended data chart. When using table calculations, grand totals and subtotals might show unexpected results. If a site's purchase date is after the period end date, then I return null; if the purchase date is before the period start date. Right-click the replacement calculation on the shelf, and select Edit Table Calculation. A union in the tableau data source screen is 100% the best way to go. Tableau Public; Data Management; Advanced Management; Embedded Analytics. Unsupported aggregations in data blending Hello, I have a distributor dataset with product ships and returns (one report covering six months), and a retailer dataset with product retail sales and stock (covering the same six months but composed of. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. Then I created a calculated field like the CASE WHEN in that post. You could add "date rows" with a union statement in your database connection and then convert this to a date in tableau using a calculated field: Date =. 0” and enter “1. Create a FIXED calc in the secondary data source to only return the latest value per name: LatestMonthPerName: [Month] = {FIXED [Name]:MAX ( [Month])} Use this new field as a data source filter on your secondary source. I have sales orders in one data source (columns highlighted blue) and account inquiry data in another (columns highlighted orange). According to the year, quarter, month, week, and day, you need a new calculated field to display the sales. See Troubleshoot Data Blending. Your visualization updates to a text table. I have two source of data: sales data from SAP and Excel file. To concatenate in Tableau: Go to the Analysis menu and select Create Calculated Field. Tableau has an answer: Data Blending. In the Data pane, right-click the Top N Customers by Sales set, and then click Create Calculated Field. Then add that new calculated field to your filters and show only true. Excel files contains only two columns: the name of category and date of premiere of category. Now we need to create a calculated field that contains all the values in the set. Open a new workbook and on the Connect page that opens click Excel. Insert the formula for Index(). When finished, click OK. Percentages are computed on the basis of the aggregation for each measure. a)) x MAX (secondary. Any chance you can upload a sample workbook. 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. {FIXED [Business Unit],[Region],[Current Month]:AVG([Billable Utilization])} Is it because we calculated Billable Utilization with aggregate functions, we have to use Table Calculation. How to use a field from Blended data source in FIXED LOD calculation? Why Tableau Toggle sub-navigation. I created calculated field 'SO Placed?' in the account inquiry data source using the following: IF [Data (Sales Orders)]. My calculation is a multiplication, and when Tableau subtotals,it's doing it in an interesting way: Formula = SUM (primary. The primary data source has: Google Play, iOS, Steam, XBOX. Tableau calculated fields from 2 dimensions. In a worksheet in Tableau, select Analysis > Create Calculated Field. Thanks for your time and assistance. Rather than trying to match across a blend, I'm using a parameter hooked in using a Change Parameter action. At that point the calculations only exist in that workbook and aren't available in the data source. ; Drag the Region field to the Color shelf on the Marks card. All of the fields from my primary data source are not aggregated, and when I bring in the fields from the blended data source for the calculation, it automatically aggregates those 2. Please see the above string for further details on my query. In the Calculation Editor that opens, give the calculated field a name. Please check the attached workbook for details. To create a calculated field: Go to Analysis and select Create Calculated Field. Is there something in the original data source that fills in that field (like a space)? edited: I think I figured out part of the problem - both the STL and Tulsa P10 2015 data sets don't even have t. Calculated fields can perform arithmetic and math, manipulate text, date, and geographic information, and use branching logic to evaluate your data and return different results. Workaround: Option 1: Instead of using Data Blend, please use Relationship to relate the data sources, and the "Only relevant values" option is available to show only existing values. What I am trying to do is create a report by store location that displays the number of customers next to the number of support tickets for any given day, week, month, year. Products Toggle sub-navigation. Parameters can hold any arbitrary values, whereas sets are always tied to a field in the data source. I'm using a multiple axis crosstab as I need to be able to color individual columns separately, but I can't sort the data on "percent to budget", it doesn't show up in the "Sort by Field" list. You can use an LOD expression to do this. These are the basic steps to run Explain Data in Tableau Desktop, Tableau Cloud, and Tableau Server: Open a dashboard or sheet in a workbook. JagThe set of data entitlements for the user is retrieved from all possible data entitlements. Tableau Desktop; Data Blending; 2 Data Sources with Identical Data Structures; Answer. The key is telling tableau which way to walk along the grid, and LOOKUP will dutifully go there. This allows to choose either the latest month or show all months. Here are the 7 major steps for putting this together: Set up your primary (main) and secondary (parameter) data sources. Move each field into below position and change the type to "Line". You will see the Total Sales field appear in the Measure Values shelf. 1 excel extract where I have the daily stock data of 1 one year. Right-click the replacement calculation on the shelf, and select Edit Table Calculation. Stacked bar chart with blended data. In the Formula text box, create a calculated field that aggregates the measure you would like to sort on. Once a relationship is defined, either in the datasource or with relationships, you can create a simple calculated field to handle the comparison. 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. Hello everyone, I am working on the accounts data of a certain financial institution. Step 2: Create the table calculation. "In the Secondary data source create a calculated field with definition as below-STR(ATTR([Primary. For a SUM() measure this looks the same as a Sum of Sums, but for an AVG() measure the Grand Total is an Avg computed across every row. You can use different approach like custom SQL join. This article describes how to create and use calculated fields in Tableau using an example. 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. In Tableau 2020. Embedded Analytics. Attached is a sample, 2 data sources are via data blending connected. For example, if the measures on Table A have a unique row identifier based on Date/Time, use that dimension to remove duplicate values. 1 or later you can avoid the need for the custom calculation and use the two pass. My question is about blending data in Tableau desktop. Format the date show that is shows the full date. In the Calculated Field dialog box, do the following and then click OK: Name the calculated field. Percentages are simply calculated as : (Count of Data Source 1)/ ( Count of Data source 2) . If this aggregation is ATTR() then the grand totals may be blank. I am working on developing a calculated field that computes the turnover rate. Tableau Data Management. Select Analysis > Create Calculated Field. Right-click the parameter and then select Show Parameter Control. CSS ErrorTo do this operation, we require the following steps: Create a new sheet. Open a new dashboard and place. [Amount])=0,'Ghost','Actual' ) Why does this show up as a. not just join table from 1 database. Create a calculation field Fail or Succeed to check whether the region reached the sales target of a certain Sub-category or not. But my main concern was, what if I have to use the same date field in the calculated fields in both data sources. It's the data on sheet 2 that I'm having trouble with in dividing the middle column (% count of sales. Create a user filter and map users to values manually. Adding the pills to the columns and rows just alters the visualization, and adding the "last: True" filter ends up. Environment. Drag a dimension to Columns. Tableau’s INDEX () function allows you to easily compute the number of weeks since opening. 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 solve, use a left join. e. 2 and work through the steps. 3) To keep only the last row create a second calculated field Whether Last or not using the Last() function and selecting the default table calculation (blue font) with the same selections as Running total above i. Using filtered data in a blended calculated field Hi all, I am trying to find a way to use a value that is passed in from an API as a filter value (it has to be a filter value) to highlight one value amongst non filtered data, essentially working like a set,Double-click State to create the map view. In my other data source I have a field called sum_total_request_count (How many total requests were made). data sources Filtering parameters Tableau Tableau Tips. 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. It appears that Window calculations are the answer. Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. Drag the New Custom SQL table from the left pane to the join area. This can affect the data included in the blend tables and change the output of the blend. This is called "DB1" for "Data Blending 1" by Tableau. Option 2: Create a calculation using WINDOW_SUM () Drag the linking field (s) from the secondary data source to Details on the Marks card. A blend merges the data from two sources into a single view. Data blending has been around for a long time – it was there before the Google Analytics connection. We will also need a calculated field that will eventually draw the top of the highlight; the formula is: IF ATTR([Ship Mode]) = [Ship Mode Parameter] THEN RUNNING_SUM(SUM([Sales])) END. 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. @Adrian Zinovei (Customer) yes, I already tried that, that only makes the Tableau workbook more complex but still won't achieve the end goal :) . Right-click the axis > Add Reference Line with the following settings. number of policies, total premium etc. In the calculation editor that opens, do the following: Name the calculated field, Running Sum of Profit. No. In the Data pane, switch to the [name of secondary data source] data source, and click at least one link icon to blend these data sources. This is what I did to create v1 of the attached. Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. In the Open dialog box, find your Excel workbook, click the Open drop-down menu, and then select Open with Legacy Connection. An example, perhaps sales progress to a target impacts the bonus calculation – i. Blending and dividing 2 data sources?? Hello! I am trying to take 2 Excel spreadsheets as data sources in Tableau and create a calculated field. The two separate table calculated fields could mean one of them being computed as table across, while the other is computed as table down. Parameter field could not be refreshed automatically, if underlying data is changed by tableau server scheduler. The actual data set I use is huge and a join is too slow. Example Using Tableau 10. Some examples. You may need to use it when creating calculated fields across blended data sources, for example. 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. Applies to: Tableau Cloud, Tableau Desktop, Tableau Public, Tableau Server. Also, if your calculated field is a regular aggregate (i. A row-level calculation is something that is computed for each record in the data. If you want to hide this column from your report, just remove the tick mark on "Show header". When creating a calculated field and then having platform as columns I get the following result: Steam and XBOX does not have revenue appearing even though the primary data source has data for those values. I have two data sources, one with costs, the other with sales. The formula that I am tried is shown in the image below and is: IF [Period] = {MAX([Data to Map From (Tableau Dummy)]. 3. Please check the attached workbook for details. Client Combined // If the Client from the transaction data is null, use the Pipieline data. shin - while your solution solves the problem for the blended data, it introduces a problem for the pivot data (NAICS code, hoovers industry, and company name); i am now getting 'asterisks' in those tag clouds. I need to create a calculation in a calculated field using information from 2 different data sources. Right-click the 2017 header in the view and select Exclude. You might want to create another datasource with these mapping data and use this data source in all other workbooks. Also, if your calculated field is a regular aggregate (i. Open a new sheet and place Sales to columns, Ship Mode to rows, and Reference Line to details. There are accounts present in the account inquiries data source that are not in the sales order data source (i. 1. I selected "Specific Dimensions", then checked on all the dimensions, and finally selected to restart every month. Loading. I then create a calculated field as follows: IIF(SUM([history_]. Step 2: Create the LOD expression. It can. if actual run time falls in between expected start and end time, file is processed otherwise failed. In the example workbook, the calculated field is named Target. This says to take all the values within a month across the Category dimension. Usually I use this technique on date fields from separate data sources. In the view toolbar, select Data Guide to open the Data Guide pane. Performing calculations with fields from more than one data source can be slightly different than an ordinary calculation. Doubleclick on one of those fields, and it will be added to your calc window. For more information, see Showing Grand Totals with Blended Data (Link opens in a new window) and Grand Totals and Subtotals Do Not Show Expected Numbers With Table Calculations (Link opens in a new window) in the Tableau Knowledge Base. Thanks .