Hi All, I am working on creating a dashboard in excel by connecting to a BI cube. That cube has information about sales, qty, profit, and profit% - by individual product The biz wants to view the above metrics by (for example, sales) by today (is there a way I can dynamically make the pivot choose sysdate whenever I open the cube via excel pivot?) by this week (which starts from Sunday - for example, if today is Monday, they want to see the sales of sunday+Monday for that product, in the week column for sales), and then by month (which means if today is 6th Feb, they want to see the sum of sales for a product from 1st to the 6th in the column). Any advise would be great, I am new here and will be grateful for any guidance. thanks all for your time. J

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

MS excel pivot query

Thread starter Jass3105
Start date Feb 13, 2023

Jass3105

New Member

Feb 13, 2023

Hi All, I am working on creating a dashboard in excel by connecting to a BI cube. That cube has information about sales, qty, profit, and profit% - by individual product
The biz wants to view the above metrics by (for example, sales)

by today (is there a way I can dynamically make the pivot choose sysdate whenever I open the cube via excel pivot?)
by this week (which starts from Sunday - for example, if today is Monday, they want to see the sales of sunday+Monday for that product, in the week column for sales), and then
by month (which means if today is 6th Feb, they want to see the sum of sales for a product from 1st to the 6th in the column).

Any advise would be great, I am new here and will be grateful for any guidance.

thanks all for your time.
J