Hello Experts
I need a bit of help with my spreadsheet I created
I have a sheet with Data and one sheet for reporting
Can someone show me how i can filter by month. At the moment it shows everyday if i click on the arrow
I need a column to show the % of the grand total
I have attached my excel file
Thanks
Rahul
Hi,
See attached. To filter on the Month the easiest way is to create a month data column. I created two new columns in your main data table (month and year) so you can select the months and or years you want. The attached file will help
Happy with my advice? Click on the * reputation button below
Hi Crooza
Thanks for that, It works
How can i calculate the percentage?
Thanks
Maybe this. See atached
Maybe try a few different scenarios to make sure they work
Hi Crooza
Thanks for your help
I am trying different scenarios as per your example
Thanks
Rahul
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks