Hi,
I'm trying to get a dropdown list box which present the dates of month.
if i select date like 12-Mar-18 then pick data for charts analysis of 12-mar-18.....
Please guide me my dashboard is not work last night i m not how to set it again.....
Hi,
I'm trying to get a dropdown list box which present the dates of month.
if i select date like 12-Mar-18 then pick data for charts analysis of 12-mar-18.....
Please guide me my dashboard is not work last night i m not how to set it again.....
Thanks & Regards,
Navi_G
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Hi,
Dear olly sir please see attach sample file.
I need this urgent Please help....
Last edited by Navi_G; 06-08-2018 at 10:46 PM.
Please reply this serious issue....
Your ideas aren't going to work very well. However, select the dates on one of the employee tabs, say
'223873'!$B$4:$B$10 and name it: chartDATES. Create your dropdown with that input range and name the linked cell reportDATE.
Create a table for the chart on the chart sheet which uses something like:
=INDEX('223873'!$B$4:$F$10,reportDATE,3)
to populate the names and perormances.
Populate the table with formulas like:
=INDEX('224504'!$B$4:$F$10,reportDATE,3)
=INDEX('224504'!$B$4:$F$10,reportDATE,5)
named ranges used in the attachment:
chartDATES ='223873'!$B$4:$B$10
reportDATE ='Date Selection'!$G$4
Ben Van Johnson
Dear Sir,
i m very glad to solved my problem with pro information...
Thanks alot sir
Navi_G
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks