2 Replies Latest reply: Feb 10, 2012 8:51 AM by paulandrade RSS

    Counting days between selection in calendar

      Hi, i am new to this. I am building a pivot table to calculate occupation in an hotel between 2 dates. I already have a pivot table with a column with number of nights sold for every room and also a calendar object to filter the data in the table by dates. I need to add another column that shows the number of days between the 2 days selected on the calendar (set to multiple values), so I can calculate ocuppation (# of nights/# of days selected)*100%).

       

      Any ideas?