0 votes

Sample Dataset:

```school  student marks
a       xyz      5
a       xyz      10
a       abc      15
b       cde      20
b       cde      25
a       cde      30
```

Goal: Find total marks, count of marks and average marks by student and school

Query: How can I create the 4th column when 2nd and 3rd columns are measures. Is it possible to perform a row level calculation?

```student sum of marks    count of marks  average marks
xyz      15              2               7.5
abc      15              1               15
cde      75              3               25

school  sum of marks    count of marks  average marks
a       60              4               15
b       55              2               27.5```
Apr 10, 2018 in Tableau 1,108 views

## 1 answer to this question.

0 votes

Yes it is possible,

Option 1:

Create a calculated field as "average marks":

```SUM(marks)/COUNT(marks)

```

Option 2:

Right click the measure and select average from the options instead of sum or count.

answered Apr 10, 2018 by
• 5,550 points

0 votes
1 answer

## How to sort by any measure in a Tableau table?

Hi Sindhu, Once you have created a bar ...READ MORE

0 votes
1 answer

## How to split or divide the grouped data into multiple graphs?

One of a simple approach is to ...READ MORE

0 votes
1 answer

## How to determine average per event by year?

Hi Roshan, Create a new calculated field (use ...READ MORE

0 votes
1 answer

## How to Split a Measure in Tableau?

Have you tried using an IF statement: IF ...READ MORE

0 votes
1 answer

## How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

0 votes
1 answer

## Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

+2 votes
1 answer

## How can I download tableau workbook with its data from tableau server?

In essence, no. Since the workbook is ...READ MORE

0 votes
1 answer

## Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

+2 votes
1 answer

## How to Link Dashboard with URL to enable it to open in the same explorer page

Add this to the end of the ...READ MORE

0 votes
1 answer

## How can I use Tableau to create a heatmap?

Step 1: Create an Excel Spreadsheet with ...READ MORE