<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>Transdate</th>
      <th>BranchName</th>
      <th>itemcode</th>
      <th>itemname</th>
      <th>Qty</th>
      <th>Unit</th>
      <th>CostPrice</th>
      <th>MarketCost</th>
      <th>UserPrice</th>
      <th>AmountItem</th>
      <th>CustomerCode</th>
      <th>CustomerName</th>
      <th>Username</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>2024-01-01</td>
      <td>Central Store</td>
      <td>N10013</td>
      <td>M&amp;M  YELLOW PEANUT 1X24X45GM</td>
      <td>50.0</td>
      <td>C</td>
      <td>44.015923</td>
      <td>45.0</td>
      <td>45.01</td>
      <td>2250.5</td>
      <td>C29598</td>
      <td>Candy Village For Sweet</td>
      <td>KHADER</td>
    </tr>
    <tr>
      <th>1</th>
      <td>2024-01-01</td>
      <td>Central Store</td>
      <td>N10013</td>
      <td>M&amp;M  YELLOW PEANUT 1X24X45GM</td>
      <td>100.0</td>
      <td>C</td>
      <td>44.015923</td>
      <td>45.0</td>
      <td>44.09</td>
      <td>4409.0</td>
      <td>C21834</td>
      <td>Cs-Crunchy Sweets Trading Est.</td>
      <td>MOHAMMED SHAFI</td>
    </tr>
    <tr>
      <th>2</th>
      <td>2024-01-01</td>
      <td>Central Store</td>
      <td>N10013</td>
      <td>M&amp;M  YELLOW PEANUT 1X24X45GM</td>
      <td>2.0</td>
      <td>C</td>
      <td>44.015923</td>
      <td>45.0</td>
      <td>46.00</td>
      <td>92.0</td>
      <td>C28832</td>
      <td>Cs-Asdhar Al Ibdah Trading Est</td>
      <td>MOHAMMED SHAFI</td>
    </tr>
    <tr>
      <th>3</th>
      <td>2024-01-01</td>
      <td>Central Store</td>
      <td>N10013</td>
      <td>M&amp;M  YELLOW PEANUT 1X24X45GM</td>
      <td>50.0</td>
      <td>C</td>
      <td>44.015923</td>
      <td>45.0</td>
      <td>45.01</td>
      <td>2250.5</td>
      <td>C24620</td>
      <td>Cs-Muassasa Athlal Junub Li Muada Adaya</td>
      <td>MOHAMMED SHAFI</td>
    </tr>
    <tr>
      <th>4</th>
      <td>2024-01-02</td>
      <td>Central Store</td>
      <td>N10013</td>
      <td>M&amp;M  YELLOW PEANUT 1X24X45GM</td>
      <td>10.0</td>
      <td>C</td>
      <td>44.015923</td>
      <td>45.0</td>
      <td>46.00</td>
      <td>460.0</td>
      <td>S20158</td>
      <td>Al-Jebal Al Aatyah Trading Est</td>
      <td>NABEEL</td>
    </tr>
  </tbody>
</table>
</div>

   Transdate     BranchName itemcode                      itemname    Qty  \
0 2024-01-01  Central Store   N10013  M&M  YELLOW PEANUT 1X24X45GM   50.0   
1 2024-01-01  Central Store   N10013  M&M  YELLOW PEANUT 1X24X45GM  100.0   
2 2024-01-01  Central Store   N10013  M&M  YELLOW PEANUT 1X24X45GM    2.0   
3 2024-01-01  Central Store   N10013  M&M  YELLOW PEANUT 1X24X45GM   50.0   
4 2024-01-02  Central Store   N10013  M&M  YELLOW PEANUT 1X24X45GM   10.0   

  Unit  CostPrice  MarketCost  UserPrice  AmountItem CustomerCode  \
0    C  44.015923        45.0      45.01      2250.5       C29598   
1    C  44.015923        45.0      44.09      4409.0       C21834   
2    C  44.015923        45.0      46.00        92.0       C28832   
3    C  44.015923        45.0      45.01      2250.5       C24620   
4    C  44.015923        45.0      46.00       460.0       S20158   

                              CustomerName         Username  
0                  Candy Village For Sweet           KHADER  
1           Cs-Crunchy Sweets Trading Est.  MOHAMMED SHAFI   
2           Cs-Asdhar Al Ibdah Trading Est  MOHAMMED SHAFI   
3  Cs-Muassasa Athlal Junub Li Muada Adaya  MOHAMMED SHAFI   
4           Al-Jebal Al Aatyah Trading Est           NABEEL  

<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>itemname</th>
      <th>AmountItem</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>657</th>
      <td>PRINGLES SMALL 12X40 GM</td>
      <td>860536.17</td>
    </tr>
    <tr>
      <th>242</th>
      <td>COMPANY KIT KAT 2 FINGER 16X36X17.7 GM</td>
      <td>695509.20</td>
    </tr>
    <tr>
      <th>656</th>
      <td>PRINGLES BIG 19X165GM NEW</td>
      <td>519913.65</td>
    </tr>
    <tr>
      <th>754</th>
      <td>TAKIS FUEGO 5X25X34 GM 1.2 OZ</td>
      <td>503590.95</td>
    </tr>
    <tr>
      <th>759</th>
      <td>TANG ORANGE 6X2 KG</td>
      <td>476670.00</td>
    </tr>
    <tr>
      <th>673</th>
      <td>REESES PEANUT BUTTER CUP 6X48X46 GM</td>
      <td>431610.75</td>
    </tr>
    <tr>
      <th>464</th>
      <td>LOACKER GARDENA SMALL 12X35X17.5 GM</td>
      <td>404436.00</td>
    </tr>
    <tr>
      <th>714</th>
      <td>SNICKERS BIG ARABIC 12X24X50 GM</td>
      <td>361288.00</td>
    </tr>
    <tr>
      <th>326</th>
      <td>GALAXY MINIS MIXED  24X500</td>
      <td>352009.20</td>
    </tr>
    <tr>
      <th>543</th>
      <td>NESCAFE GOLD 6X190 GM</td>
      <td>311737.00</td>
    </tr>
  </tbody>
</table>
</div>

                                   itemname  AmountItem
657                 PRINGLES SMALL 12X40 GM   860536.17
242  COMPANY KIT KAT 2 FINGER 16X36X17.7 GM   695509.20
656               PRINGLES BIG 19X165GM NEW   519913.65
754           TAKIS FUEGO 5X25X34 GM 1.2 OZ   503590.95
759                      TANG ORANGE 6X2 KG   476670.00
673    REESES PEANUT BUTTER CUP 6X48X46 GM    431610.75
464     LOACKER GARDENA SMALL 12X35X17.5 GM   404436.00
714         SNICKERS BIG ARABIC 12X24X50 GM   361288.00
326              GALAXY MINIS MIXED  24X500   352009.20
543                   NESCAFE GOLD 6X190 GM   311737.00

Vizly: AI-powered data analysis

Analyzing Sales Performance by Branch Over Time

Can you visualize sales by branch over time?

Can you analyze the top-selling items?

Visualize this for me