Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Data table with two keys

I have a data set of material consumption. The table has both which material is consumed aka "Material" and where it is consumed "Order".

 

For modeling Material is made the key field. However for one specific purpose I.e. showing consumption chart of material, need to sum Quantities by Order and not material field.

 

Pls note in most pages of my report, slicer of Material exist, hence I am finding it very difficult to sum quantities by Order.

 

Anyhelp would be appreciated.

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      I did, but then it doesn't sum up quantities at all.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Let me repharase the situation of my model a bit. I have this matrix situation and slicer is set for product/ material, so it is filtering what materials are used for production of each product. i need to change filter context for one visual so it shows me products to product consumption.