Create Pivot from table

Question

Hi there,&nbsp;i have a table that contains 3 columns1 - "Conteggio Scontrini" -&gt; trad: Count Receipts2 - Date3 - "Carta" -&gt; Fidelity Card No_&nbsp;Each row shows how many receipts were issued that day for that fidelity card.&nbsp;I would like to have from this table a representation something like Pivot.Example below in Excel.&nbsp;&nbsp;So, how many fidelity cards have a receipt, how many 2, how many 3, etc etc etc.Taking the dates into consideration, it must therefore be not static but dynamic data&nbsp;Please help meAll the best&nbsp;&nbsp;

mani_1 · Answer

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

z_bi · Answer

Hi&nbsp;Mani_1&nbsp;,&nbsp;thnx to reply.If I do what you show me the results is not good.&nbsp;&nbsp;Applicated COUNT in "Conteggio di carta". I need to have "COUNT RECEIPES" divied&nbsp;1234etc etc

mani_1 · Answer

Hi&nbsp;Z_BI&nbsp;,Can you provide sample data??

z_bi · Answer

Sure, here below.Table datesIn report, at the moment, i have this visualField "Carta" - no summerizeFiled "Conteggio Scontrini" - SUMmy 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....&nbsp;Let me know if you somenthingthanx for your support&nbsp;All the best&nbsp;

Forum Discussion

Create Pivot from table

4 Replies

Related content

Create pivot table visual

Create new table

Lakehouse Table Generate Create Table

Created Avg Price measue without pivoting table

Create Pivot table