class ProductSalesPerCountryCrosstab(ReportView):
    report_title = _("Product Sales Per Country Crosstab")
    report_description = _("Demonstrate a crosstab/pivot on pre-set IDs (US, KW, EG, DE). "
                           "The remainder column collects sales from all other countries.")
    report_model = SalesTransaction
    date_field = "date"
    group_by = "product"
    crosstab_field = "client__country"
    crosstab_columns = [
        SumValueComputationField,
    ]

    crosstab_ids = ["US", "KW", "EG", "DE"]
    crosstab_compute_remainder = True

    columns = [
        "name",
        "sku",
        "__crosstab__",
        SumValueComputationField,
    ]