Hi,
I am creating a link expression in a pivot table, and it's not working. In the straight table works perfectly, but I will need that the fields are being grouped by family - first, then type, code and sub-code. The link expression will be in the code. For example:
Wood tools >Hand >1223 >1
Wood tools >Hand >1223 >2
Wood tools >Hand >1223 >3
In a straight table you will have one row per record, but in the pivot table you will have only
1
Wood tools >Hand >1223 >2
3
I will like to have the code in a link expression, instead of have it that way I will have something like:
Wood tools >Hand >code >1
total
Wood tools >Hand >code>2
total
Wood tools >Hand >code>3
total
Any idea on how to do it?
