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

Cross Table Year over Year Calculation


jackson ejm

Recommended Posts

Hi,

 

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.

 

Regards,

 

Vidya

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...