We want to understand your data structure and could you please attach small sample of your original data ?
csv excel format is fine but twbx is the best.
I modified the first post,
thanks for help
thanks for the hint, I have some trouble with it :-(
on calculated fields I can not see option for pivot in the right click menu.
it is not 100% clear for me what happens when I select pivot, it creates new columns? how those columns named?
After I select pivot, I receive a message when I want to use the column other places, that: 'The field XX does not exist in the database'
If I understood it correctly, it totally replaces the original table, but I have to use the original data at other places...
Pivot is the first step before creating any calculation and you cannot pivot calculated field.
But After pivot, you can still re-create same-functional-calculation.
Instead, without pivot, it Very difficult to get your expected result regarding the issue your posted.
If you could attach a set of sample data, we can assist you to re-create existing formula.