Sample workbook, please.

As Shawn suggested a sample Workbook would be optimal so we can see what you are trying to accomplish.  Check out the workbook I've attached.  I'm not sure that's what you are looking for but its a start. 

I'm not 100% sure since I've yet to dabble in v8 , I'm still new to v7,  but I wouldn't see why not.

Armando,

     Can you post a sample of your work book so I can see what you really need?

Gerardo

Hi Armando. Welcome to the forums. Have you read this wonderful guide Tracy put together? If not, you really should; it might help you, help us, better help you.

Thanks,

--Shawn

Hi Armando.

You do make a good point: someone is going to have to spend time generating DUMMY data. It has been my experience that the questioner is in the best position to do this tedious task, especially considering they 'know' the sensitive data better than anyone else can guess what it looks like; don't you think?

And by the way what does this mean: CumplimientoObjetivo ?

Hope you'll take the time to help us answer your question. But if not, there's always tech support, they're really good at dealing with stuff like this.

--Shawn

Shawn,

I've been a long time lurker and this is my first attempt to solve someones problem, please correct me if I make a mistake.  "CumplimientoObjetivo" translates into Compliment Objective.  By the look of the screen shot he posted he is comparing compliments items/services sold by different stores. So I believe Armando is looking for the  COUNTS of both the compliments and lack there of. 

Gerardo

Hi Gerardo thanks for the translation. I am totally language-challenged and envy all you multi-lingual forum folks!

So if you were going to try to "represent" his data, and question, how would you do it? I usually use SuperStore to start, but maybe his is really unique data. So help me out a bit, what does this image mean:

And what should we substitute in for his sensitive data? And can you produce an Excel spreadsheet we can all experiment with to get where he's trying to go? It would be great if you're willing to help out with this! (And why couldn't he do it?)

My Point: At some point someone needs to spend less than the time I took to write this response to produce some sample data which represents the data structure that isn't working, so we can help him. Who should do that?

--Shawn

Shaw,

     I think the problem is that the CumplimientoObjectivo, by the way I translate wrong its more like duty/promise objective, is a calculated field and you can't aggregate an aggregate. I'm not sure how he wants to display the data which changes how you approach the problem. Attached is a quick and dirty solution

-Gerardo

Yes Gerardo I too am curious. Thanks.

--Shawn