Service offering field is not in "Auto SD" worksheet that's why you are getting the error
Add the service offering field to detail in mark section in Auto SD sheet automatically your actions will work
Hope this helps
Plz mark this answer as correct or helpful to close the thread
The service offering field is in the filters of AutoSTD and I can't add it to the detail as that would split my trend into separate lines, one for each service offering.
Use the LOD or table calculations to make sure that Service offering in Detail or worksheet level instead of filters, because filters not treated as detail
its best you can recreate a problem with superstore data and attach a twbx
I have no clue how I would use a LOD for this.
Attached a simplified version of what I have to the question.