Products by category

[set first_done][/set] [search-region more=1 search=" ra=yes st=db fi=products ml=999999 tf=category to=x tf=artist to=x "] [set first_done_category][/set] [set first_done_artist][/set] [search-list] [item-change 1][condition][item-data products artist][/condition] [/item-change 1] [set first_done_artist]1[/set] [item-change 0][condition][item-data products category][/condition] [/item-change 0] [set first_done_category]1[/set] [value name=prev_data_artist hide=1 set=|[item-data products artist]|][value name=prev_data_category hide=1 set=|[item-data products category]|] [/search-list] [/search-region]
[if scratch first_done_artist]
[value prev_data_artist]
[/if]
[if scratch first_done_artist]
[filter op=|'currency'| interpolate=1][summary name=subtotal.products.price.artist total=1][summary name=subtotal.products.price.artist reset=1][/filter]
[/if]
[if scratch first_done_category]
[value prev_data_category]
[/if]
[if scratch first_done_category]
[filter op=|'currency'| interpolate=1][summary name=subtotal.products.price.category total=1][summary name=subtotal.products.price.category reset=1][/filter]
[/if]
sku category artist title price
[page href="config/edit_record" form=" mv_action=return mv_data_table=products mv_arg=[item-data products sku] "][item-data products sku] [page href="config/edit_record" form=" mv_action=return mv_data_table=cat mv_arg=[item-data products category] "][item-data products category] [filter op=|'name'| interpolate=1][item-data products artist][/filter] [item-data products title] [filter op=|'currency'| interpolate=1][item-data products price][/filter][summary name=total.products.price hide=1 amount="[item-data products price]"][summary name=subtotal.products.price.artist hide=1 amount="[item-data products price]"][summary name=subtotal.products.price.category hide=1 amount="[item-data products price]"]
[if scratch first_done_artist]
[value prev_data_artist]
[/if]
[if scratch first_done_artist]
[filter op=|'currency'| interpolate=1][summary name=subtotal.products.price.artist total=1][summary name=subtotal.products.price.artist reset=1][/filter]
[/if]
[if scratch first_done_category]
[value prev_data_category]
[/if]
[if scratch first_done_category]
[filter op=|'currency'| interpolate=1][summary name=subtotal.products.price.category total=1][summary name=subtotal.products.price.category reset=1][/filter]
[/if]
TOTAL [filter op=|'currency'| interpolate=1][summary name=total.products.price total=1] [/filter]