# 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]
|  | [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]
[/item-change 1] [set first_done_artist]1[/set] [item-change 0][condition][item-data products category][/condition]
| [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
--- | --- | --- | --- | ---
[/item-change 0] [set first_done_category]1[/set]
[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]"]
[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]
|  | [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]
[/search-region]