Issue with Grouping Aggr of Summary on one Dimension

[Peter_Brunner]

Hi all,

I have been trying several different approaches but none have worked I am missing something here

I wish to group the Category field Only  but for some reason I need the Location Field to bring up my data

I need the total to match in details table and in summary table.

please see attached

any help appreciated

thank you

regards Peter

[swuehl · Accepted solution]

Try an aggregation, maybe

=Sum(if(([SLOW QTY])>0,([SLOW QTY]),0)*[EACH VALUE])

Use Aggregation Functions!

[Peter_Brunner]

Hi Stefan,

thank you for you guidance, and I looked a the informative links and did a bit of re work on structure and have got a result thanks

regards Peter