Jump to content
We've recently updated our Privacy Statement, available here. ×

Cross Table Year over Year Calculation

jackson ejm

Recommended Posts



If you get the data in the below format you can achieve your requirement.


[[{"fid":"134766","view_mode":"default","fields":{"format":"default","field_file_image_alt_text[und][0][value]":"","field_file_image_title_text[und][0][value]":""},"type":"media","attributes":{"height":"383","width":"421","class":"media-element file-default"}}]]


But the question is how do you get this format There might be multiple options to achieve this requirement. But I have few suggestions for you to try it. If not I can give a try for you.


Step 1: Try to create an output table like above table structure using TERR.


Step2: Once you have the output table append it to the existing table (Insert -> Rows).


Now your cross-table should show you the format of what you are asking for.





Link to comment
Share on other sites

  • 1 year later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...