2 Replies Latest reply on Sep 4, 2018 9:18 AM by Calvin Wu

    Average on summary - help

    Calvin Wu

      Hi I am new here, I have been struggling to figure out how to get the average of summary, in this case, average hotel nightly rate.

      So I have total nights of stay in hotel, and total hotel spend, I am trying to get the average nightly spend on hotel for various business units. It's easy to create a pivot table in excel but seems pretty complex in Tableau. Anyone can help on this? Really appreciated!