10 Replies Latest reply on Jul 21, 2015 6:23 AM by

# PLS HELP ME

QUARTER ,   MONTHS,       QUANTITY,  SUM (QUANTITY)

Q1                 JAN                    1

FEB                    2                    6

MARCH               3

Q2                  APRIL                 4

MAY                    5                   15

JUNE                  6

Q3                 JULY                   7

AUGUST             8                     24

SEPTEMBER       9

NOW MY QUESTION IS HOW CAN ACHIEVE  SUM(QUANTITY)=6 FOR Q1

AND SUM(QUANTITY)=15

LIKE   Q3=24 AS SHOWN ABOVE

WHAT SHOULD WE WRITE IN CALICULATION FIELD?

• ###### 1. Re: PLS HELP ME

You don't really need a calculated field for this scenario. The order in which you drag your dimensions or double click the dimensions, tableau groups them accordingly. So if you bring quarter and month on the view and then double click the quantity, you should get the view you are seeking. Then by going to the analysis tab and selecting totals > add all subtotals, you will get an additional row per pane totaling the quantity by month and quarter. Or you can use a window calc like : window_sum(sum([Quantity]))

Set it to compute using pane(down).

• ###### 2. Re: PLS HELP ME

what is the difference between pane,cell and table

On Thu, Jul 16, 2015 at 9:07 PM, Pooja Gandhi <

• ###### 4. Re: PLS HELP ME

Hiii

How to display top 5 and last 5 in same view

On Fri, Jul 17, 2015 at 8:49 PM, Pooja Gandhi <

• ###### 5. Re: PLS HELP ME

how many max columns we can use in tableau?

On Sat, Jul 18, 2015 at 12:35 AM, praveen reddy <praveenvizql@gmail.com>

• ###### 6. Re: PLS HELP ME

praveen reddy wrote:

how many max columns we can use in tableau?

Praveen, you can use a maximum of 16 columns, although you can get more if you have to >> Sometimes You Have to Break the Rules. Expanding Beyond 16 Columns without Header Concatenation | Tableau Software

May I suggest that if you have additional questions that you start a new thread... Pooja has been very helpful but your asking a lot of questions and maybe others can also help...

Cheers

Mark

• ###### 7. Re: PLS HELP ME

Thanks Mark, sometimes I read emails/notifications when I am at home without access to Tableau and then it skips my mind to respond when I am at work

• ###### 8. Re: PLS HELP ME

I thought Id jump in to give you a hand

Praveen, is there anything outstanding on this thread?

Cheers

Mark

• ###### 9. Re: PLS HELP ME

Thank you mark fraser

• ###### 10. Re: PLS HELP ME

HII pooja