Cross Table Year over Year Calculation

[jackson ejm]

hi,

i would like to do a year over year in a calculation table.

[vidya sagar Malla]

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

[Nawaz Ali Mohammad]

Hi, you may want to check the below Community answers which calculates Year Over Year calculations.

Link :https://community.spotfire.com/questions/year-over-year-calculation-cross-table