This content has been marked as final. Show 2 replies
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%).