Search:

Type: Posts; User: Tommy2Tables; Keyword(s):

Search: Search took 0.00 seconds.

  1. Equivalent of Sigma Values for pivot tables in LibreOffice Calc

    We have volunteers who won't spend the money to get Excel. But our training comes from Excel things. For pivot tables, Calc does not have a Sigma Values to set up. What is the work around? Thank...
  2. Re: Lost my column headers. Table starts with A2. excel 2010

    fOUND IT. Row just hidden combined with an accidental insert above. Thank you.
  3. Re: Lost my column headers. Table starts with A2. excel 2010

    Thank you! I thought I was out of luck post late on a friday before a holiday. I could not find the sticky on how to insert a sheet, so i recreated here.

    <tbody>

    A
    B
    C


    2
  4. Lost my column headers. Table starts with A2. excel 2010

    What did I do to it?

    When I make a pivot table, it starts at the A2 level. If I delete and rename the A2 row, it remembers the now hidden header column in the pivot table. Making it all a table...
  5. Re: The traveling salemen who got sick. Sorting the suspected customers after counting in a pivot table.

    excel 2010. I got it to run. I don't know if it was deleting excess columns or deleting blank spaces or rebooting the computer, but I have had success. Thanks
  6. Re: The traveling salemen who got sick. Sorting the suspected customers after counting in a pivot table.

    Thank you Debbie S.
    T2T
  7. Re: The traveling salemen who got sick. Sorting the suspected customers after counting in a pivot table.

    Ooops. I got it . In PT I need to pick a value in the Count column, then, sort; outside of Pivot Table, you can pick the whole column. Derp.
    I am still getting crashing because of the size of...
  8. Re: The traveling salemen who got sick. Sorting the suspected customers after counting in a pivot table.

    How did you get the Count of Customers to Sort? I know that you can reuse the field CUSTOMERS in both the PT Row Labels and Values (as Count of CUSTOMERS), but when I try to Sort on the Sort &...
  9. The traveling salemen who got sick. Sorting the suspected customers after counting in a pivot table.

    The salesmen who visited these customers all got sick. I want to find which are the most common customers in the list. I want to sort the count of how frequently a customer shows up in a COUNT in...
  10. Re: Where did the traveling salesman get the flu?

    I did not respond because this solution and the other one blew my mind. I am going to try to take on smaller chunks of this at one time. Thank you. T2T
  11. Where did the traveling salesman get the flu?

    I want to find what person is most likely to have infected my salesman.
    I have two tables, one of sick salesmen and their customers and the well salesmen and their customers.
    The customers...
Results 1 to 11 of 11