## Sign up to take part

Registered users can ask their own questions, contribute to discussions, and be part of the Community!

This website uses cookies. By clicking OK, you consent to the use of cookies. Read our cookie policy.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Registered users can ask their own questions, contribute to discussions, and be part of the Community!

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Solved!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

How do I create sum or total data in same column on dashboard?

Name Week1 Week2 Week3 Week4

A 10 20 30 40

B 41 31 21 11

C 3 4 5 6

I want the dashboard shows

Name Week1 Week2 Week3 Week4

A 10 20 30 40

B 41 31 21 11

C 3 4 5 6

Total 54 55 56 57

or

Name Week1 Week2 Week3 Week4

A 10 20 30 40

B 41 31 21 11

C 3 4 5 6

Total 54 55 56 57

--------------------------------------------------------

Grand total 222

Or modify the data table to use sum in the same column.

Thank you.

1 Solution

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

With such a small table the easiest is to use a recipe to get the final table you want, then publish it to the dashboard.

Here is an example using only a visual prepare recipe, it involves transposing, computing the sum, then transposing back.

Another solution to only get the sums is to use a prepare recipe to Fold your data (the opposite of a pivot), then use a groupby "Week" to get the sums.

Solutions shown first - Read whole discussion

3 Replies

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

With such a small table the easiest is to use a recipe to get the final table you want, then publish it to the dashboard.

Here is an example using only a visual prepare recipe, it involves transposing, computing the sum, then transposing back.

Another solution to only get the sums is to use a prepare recipe to Fold your data (the opposite of a pivot), then use a groupby "Week" to get the sums.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I see trans > sum > trans back > total.... nice idea

Thank you cperdigou.

Thank you cperdigou.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content