Forum Discussion

Z_BI's avatar
Z_BI
Frequent Visitor
2 years ago

Create Pivot from table

Hi there,  i have a table that contains 3 columns 1 - "Conteggio Scontrini" -> trad: Count Receipts 2 - Date 3 - "Carta" -> Fidelity Card No_   Each row shows how many receipts were issued that...
Need Help
Tips and Tricks
Mani_1's avatar
Mani_1
Frequent Visitor
2 years ago

Hi Z_BI ,

In the report view select matrix or table in visualization and add Conteggio Scontrini,Carta in columns. Then right click on feild and select "count". similarly you can add filter from visualization, add date into it.

 

Thanks

  • Z_BI's avatar
    Z_BI
    Frequent Visitor
    2 years ago

    Hi Mani_1 , 

    thnx to reply.

    If I do what you show me the results is not good.

     

     

    Applicated COUNT in "Conteggio di carta". I need to have "COUNT RECEIPES" divied 

    1

    2

    3

    4

    etc etc

    • Mani_1's avatar
      Mani_1
      Frequent Visitor
      2 years ago

      Hi Z_BI ,

      Can you provide sample data??

      • Z_BI's avatar
        Z_BI
        Frequent Visitor
        2 years ago

        Sure, here below.

        Table dates

        In report, at the moment, i have this visual

        Field "Carta" - no summerize

        Filed "Conteggio Scontrini" - SUM

        my need, in a simpler way, is to answer this question: "in a given period of time I select how many loyalty cards have had a receipt? How many 2? and so on....

         

        Let me know if you somenthing

        thanx for your support

         

        All the best