Search results

Hello, I am trying to show forecasts with cumulated data. My data table is as follows: ID - unique identifier A Revenue - number or "-" if empty A Margin - number or "-" if empty A Margin% - formula: =iferror([A Margin]/[A Revenue],"-") B Revenue - number or "-" if empty B...

Hello, I don't know if it's because it's Monday, but I can't find a way to do something which I feel should be very basic. I have a data table (containing survey results) which I base many pivots on. In one of the pivots, I need to compute / calculate averages or counts of responses only when...

Hi, I'm using powerpivot to process survey data. I created a date dimension table, that is referenced by other tables containing dates. It looks like this: DateKey MonthNumber MonthName Fiscal Quarter Calendar Year Fiscal Year 4/30/2013 4 Apr Q2...

I'm working on a shared file, and one of my teammate needs also to work on the same file simultaneously. I know we are not performing changes to the same tabs in the file, so there will be no overlap. So I chose to work on a copy of the file, so as to keep progressing. Now, when she will...

I need to be able to count how many distinct ProjectID are in my table with the following criteria: PorjectID should be counted if it appears [list type=decimal] in the given quarter, for a given region, but not if it was already existing in previous quarters. The following array formula...