Search results

Hi, I have 2 million records and want to do time intelligence analytics once the data is in proper shape. I have already attached the sample file(chandoo.xlsx)-with explanation in the output tab. pls let me know if anything else you need. BR Brij

Any expert can reply pls :(

Any updates or its too complex?

Hi Narayan, Thanks,PFA the sample file with output as explanation. Data size is in millions so would like to use powerquery/PBI and ontop of it want to utilize PBI time intelligence visuals for analytics.

Hi Experts, I have high hopes from you to solve this tricky powerbi automation requirement. I have attached the screenshot of how i want the output at the end. I want to keep year 2014 as reference . So if any supplier with some part number in some plant as shown in image has no 2014 rate then...

Please let me know if any further clarification is needed in any case? Thanks, Brij

Dear Team, I'm a member of Chandoo powerpivot and excel school but not sure if i can get privilege support there in asking question or where to ask the question so thought of writing it here. I need to know how many times the price increases in same year,same month,same plant/multiple plants...

help pls

can any Expert pls help..

Hi Tomas, Yes exactly,also if i include other fields from pivot like plant name,commodity name the numbers should come correctly. How you did that?Is it possible? Please share... Thanks,

pls help...

Dear Experts, I want to create basically 1 pivot table which can summarize my all KPI's .for example-spend,quality and delivery to be combined in one pivot table.How can we do that,i tried using power pivot and created separate tables for region,month (unique) and linked to the kpi data but...

Dear Experts, I have huge data set containing almost 1 million records and when i try to create pivot table out of it it throws me an error saying cannot complete the task with available resources.How to deal such situations as i want to show both data and pivot out of it. I'm using excel 2013...

Hi Narayan, Thanks a lot for solving this quickly :) and making me learn too. Regards,

Hi Narayan, Exactly Yes. Thanks,

Hi, can anyone help me on this pls.. Thanks,

Hi Narayan, Thanks, let me try to explain- In tab "Conflict Minerals BU-CL Part" in column "status"(I) i need to have a formula to calculate Responded and not Responded supplier Id(col B). The criteria is- if in tab "Conflict Minerals BU-CL Part" column "Validation status has either of these...

In the attached file i need to find the output in status column(I) based on criteria tab. I have tried explaining the logic in column I. Please let me know for any clarification if I'm not clear. Thanks for your support.

Hello Abdul, Do you think i dont know pivot,my requirement is that i have 3 data sets in different sheet which have many common fields except the measured field like spend,quality products,savings in all 3 diff sheets now i want to have one single report combining all in one pivot. Regards,

Dear Experts, I have a requirement where i have there separate reports where all the dimension fields like region,country,location are common to all reports but only the measured fields changes like delivery on time,savings,No of quality products.I need to join all these 3 tables into 1 pivot...

Im in favor of you Vijay.Appeal to Chandoo and all Experts :)

Hey Hui, thanks for this.I think i need to apply custom filter and then record the macro. I got it thanks so much. Regards,

Hi people, Can any one please update me on this. Thanks in advance. Regards,

Any one pls help me on this.

Hi Experts, can anyone give their expert addvice. Many thanks,