Search results

hi Narayan, I really appreciate your time - and thanks so much; it worked perfectly. thanks again :) C

Hi all, any assistance is appreciated. Is it possible to take the field name of a structured table and use it as a criteria in a countifs statement? e.g. if i have the field name "cereal" in cell A1, is something like =countifs(table1"["&A1&"]","cocopops") possible (i tried this, but it didnt...

Hui, thanks again for your patience and efforts; i hope im not being too difficult LOL Hi the objective was to show the fields with no records as well as those with entries when any location is selected from the location filter. But i dont want programs listed against outcomes to which they...

Hi Hui, Ive been diverted to other jobs so just getting back to this. thanks again for ur ongoing support. I accessed the google version - not sure whats changed? :) Chris

Hi hui, sorry for the autocorrect on ur name in the above :) Anyway, thanks for trying to find a solution for this - much appreciated. Unfortunately, when I tried ur suggestion, the report still filters out items With no values. :| thanks again :)

GUI, thanks so much for ur response. This is a Good compromise solution. However, I kinda need The outcome field as a row label. It seems that Excel cant see the dependant relationship between the program and outcome fields? I think I might try using Countifs. Thanks again for all ur...

Hui, thanks for ur quick response and pls accept my apologies for not reciprocating :) In the file, I have a pivot that is filtered by location. The pivot has three columns: outcome, program and $ Each program is associated with only one outcome. I wanted to show all programs under each...

Hi all, just wondering if this is a problem for others I would like to show items with no data on subcategories of data in a pivot table (excel 2010) . When I do this, the pivot table shows every item for every sub category and category. E.g for three categories which each have 6 separate...