Search results

Hello, Am looking for a formula which gives me no.of weeks in a month i.e. week1, week2, week3,week4 & week5 based on date likewise for full year. Ex: I have a data for full year that contains no.of tickets processed on each workday. Based on date i.e. 1-Jan-13, i want to contruct a formula...

Forgot to mention in previous mail. Adding to previous description, Working days = start from Monday 6:00AM to Saturday 2:00AM Non-working days = Saturday 2:00AM to Monday 6:00 AM Therefore i want a formula to classify the ticket submitted dates as working hours & working days and...

Hi Hui, Sorry for unclear question. Please refer to description of my requirement below: I want to calculate no.of issues logged by customers during working hours and un-working hours where my working hours in a day is 20 hours out of 24 hrs because our team support critical issues...

Hi Chandoo, I'm looking for two formula as per my requirement given below: 1. From datetime format (1/1/2013 12:51:13 AM) - how to extract only time into a separate cell? 2. Our shift start at 6AM & ends at 2AM. Ex: If i start my shift on Monday morning at 6AM it goes upto 2AM on Tuesday...

Hi, This is not am looking for..actually source data & target data are of different files/workbook but not same sheet. Secondly, through some lookup formula i want to link both the files and then concatenate the text that matches the parameters (eg:similar to sumif where it sum the values and...

Hi, My question after observation is that "why grand totals are not selected/coming in powerpivot charts"? Is there a way where we can see that grand totals also appear in stacked chart. Please help!! Thanks, Vamshe

Hi, Am looking for a similar formula like sumif which will add/concatenate text data from one sheet to another. See the example below: Source file data- Name Travelled Region A USA B APA C EU B USA C APA B EU Name Region A =(formula) i.e. USA B =(formula) i.e. APA/USA/EU C...

Hi Luke, I tried NETWORKDAYS but not get exactly might be some formula error. For your reference am herewith providing two regions holiday list below. Could you please build a formula to calculate work days in a month excluding saturdays, Sundays & holidays: HDate Holiday...

But Totals are not coming in pivot chart as i have shown earlier (as per the attacment).

Hi, Could you please provide me a DAX formula (powerpivot/measure) wherein i can calculate no.of workings days excluding saturdays, Sundays & Holidays based on two different regions. Thanks in advance. Regards, Vamshe

Hui, Could you please advise me with my requirement. How to get totals on the top of each bar in a stacked column chart? When i tried with each series separately (as suggested above)then there is a problem that if am selecting items in the slicer (powerpivot) then the chart is not getting...

Hi Hui, Otherwise is it possible to show just total on the top of each bar in stacked column chart instead of showing 3rd series separately. Which means i will give data range as i have shown in the sample but in that we don't have total or sum of permanent & temporary on the top. Is there a...

HI Hui, Am able to see total series now. But when am selecting manager in the slicer then the chart is not align to changing no.of rows & colums. Is there any way that we can see to that chart is aligned to pivot table while selection is made in slicer. Regards, Vamshe

Hi Hui, I have tried as you said but it is not working. 1. Am not able to select series separately with comma(,) 2. Once after selecting a data range then that field itself is getting disabled and no chance of any selecting one more column/'s. Please help me. I don't think this is...

Please find the link http://www.2shared.com/file/I53GmC6c/Example.html sorry i don't how the link got missed out in earlier mail. Regards,

HI Hui, I have attached sample file for your easy understanding and the link is below. Regards, Vamshe

Hi Chandoo, I need your help in solving my problem which am facing & trying from past one week to find a solution. About the problem: I have a employee database which consists of Managers, Executives,Permanent & Temporary etc. Same data i have kept in pivot table which has given me the...