I have a view called product, it has the following columns:
Year Quarter Region Product Invoices Sales
2006
Q1
Eastern
Q2
Eastern
Western
Southern
Volvo
BMW
Toyota
Inv 1 USD20K
Inv 2 USD30K
All first 4 are categorised columns:
i have the following formula created, but don’t know why it does not work:
@Command([ViewCollapseAll]) ;
@Command( [OpenView] ; “Product” ;“Toyota” );
@Command( [ViewExpandWithChildren] )
What I wanted is actual for the view to expand up to level 3, i.e product, but I don’t know how to specify the category, as the column refers to field ProductField.
Any help very much appreciated, tq in advance.