I'm trying to set up a widget (pivot) where I can display the revenue for our categories from last week and from the same week last year. I have the categories as the rows and it is my hope to have last week's revenue in one column and same week last year in another. I can get the proper data, but when trying to display both in the same widget, it just display's the same date range depending on which column I modify last. I've attached a screenshot of how I'm trying to display the data. TIA
Please sign in to leave a comment.