Hello,

I am new with Zoho Analytics and would like to know how could I link two separate report tables/pivot tables?

I have pivot views: sales and detailed sales

These views has filter OrderNo

In sales viewI have OrderNo, totals sale price

In detailed view I have grouped data: Order no, item category, quantity, price 

By clicking total sale price I want to open second view with Grouped information. 

I saw there is possibility to use links. But how could I put Link on Total sale price and when clicking open second pivot table with OrderNo filter set already?

I hope you understood what I mean. "View Underlying Data" is not an option.

Looking forward to any suggestions.