Forum Discussion
nicnic38
1 year agoFrequent Visitor
multi levels calculations
hello, i'd like to calculate complex (for me) calculation to obtain specific results. The aim is to avoid temporary table in order to calculate whatever the selection of the data is. My data...
nicnic38
1 year agoFrequent Visitor
look great... for my sample.
my dataset is much more complex :
- "group" has 50 values
- "subgroup1" has more than 200 values
- "subgroup2" has from 4 to 10 values dependnaing on the value of subgroup1
thanks again for help
lbendlin
Super User
1 year agoPlease provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
- nicnic381 year agoFrequent Visitor
here is the dataset : https://drive.google.com/file/d/1DS44dI23jA_YRSB_JqXSiGyqa4J5HmUW/view?usp=drive_link
- lbendlin1 year ago
Super User
Access denied.
- nicnic381 year agoFrequent Visitor
the data file is updated