8 Replies Latest reply on Nov 22, 2016 12:57 AM by Julien Mougenot

# Aggregated Field

Hi Everyone,

I'd like to add one column called "Rental Listing (House & Unit)" which sum for each month the total number of rental listings for house and unit.

Result would 23 (16+7) for May and 28 (18+10) for June. Don't mind if each result is repeated twice.

Any assistance on this would be appreciated. It may look simple, but I've already spent a number of hours on this.

Julien

• ###### 1. Re: Aggregated Field

Hi Julien,

Find my approach as reference below.

{fixed Month, Year of Month: sum(Rental Listings)}

1 of 1 people found this helpful
• ###### 2. Re: Aggregated Field

Hi Julien,

Please find the attached workbook for reference.

You have to enable "Grand Total" on Analysis selection.

Then modify the Grand Total label as per your column name

Thanks

Akram

1 of 1 people found this helpful
• ###### 3. Re: Aggregated Field

Thanks Norbert.

If I use month as suggested, it sums the rental listings across all suburbs for that month. But you couldn't know that considering the screenshot I gave you.

So I've created a calculated field with the following calculation: {fixed[Suburb]: sum([Rental Listings])}

It's close but not there yet. I need to add one fixed dimension such as Property Type for example.

Would you know that calculation syntax to combine two fixed dimension?

I've tried: {fixed[Suburb] and fixed[Property Type] : sum([Rental Listings])} but Tableau doesn't like it.

Thanks,

Julien

• ###### 4. Re: Aggregated Field

Hi Akram,

I've proceeded as instructed:

But when I select Analysis > Totals > Show Row Grand Totals, I get the following error message:

Plus moving forward I'd like to use this Grand Total in a calculated field.

Julien

• ###### 5. Re: Aggregated Field

If I'm understanding correctly, you want the sum for each suburb for each month. There are multiple ways to do this, but since the LOD approach seems to be the one being discussed you could try:

{fixed [Suburb], [Month] : sum([Rental Listing])}

This will "fix" the calculation of the sum at the level of suburb and month. Of course, if you have multiple suburbs with the same name/code in different states they would all be combined since [State] isn't being included.

Without seeing the data, I'm not sure, but the following might also work:

{exclude [Property Type]: sum([Rental Listing])}

I'm still learning the details of LOD calculations, but hopefully this is helpful.

-marc

• ###### 6. Re: Aggregated Field

Hi Julien

I have updated the workbook as per your requirements.

Calculated filed equivalent to "Grand Total" created with "Windows_Sum" formula.

Thanks

Akram

1 of 1 people found this helpful
• ###### 7. Re: Aggregated Field

Marc, in two words: THANK YOU!

The exclude calculation works perfectly.

Julien

• ###### 8. Re: Aggregated Field

Thanks Akram. It works!